Posted 5/18/2021 06:26 (#9011106 - in reply to #9010959) Subject: RE: Has anyone made a grain inventory database in Microsoft Access?
I have a pretty extensive Excel file with pivot tables to show inventory and yields. I do not use it to track sales (have another file for that, it links to insurance APH’s/field acres to show current % sold). My inventory file will produce reports for bin inventory, yields by field, farm, or insurance unit, yields of a certain crop over the years, acres by crop, bin capacity. The main data table is a database with one line for every scale ticket (or a line for every quantity in a bin from a specific field). If you’d be interested in taking a look, shoot me an email and I will make a version with a small amount of sample data.