AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Has anyone made a grain inventory database in Microsoft Access?
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Kit
Posted 5/18/2021 15:20 (#9012037 - in reply to #9010959)
Subject: RE: Has anyone made a grain inventory database in Microsoft Access?


OK Panhandle
Thinking about what you're trying to do, I think splitting inbound and outbound into different tables is complicating things. If you think about it, they are both just grain movements - either a debit or a credit. If you follow strict double-entry accounting practices, you could keep all the information in one table, plus then you have a built-in audit log if you need to research something. Would sure make running queries easier because you could just tell the database to sum all the activity for bin X to get a balance, or run a group by on owners to get balances for each owner, or run a group by on bins to get inventory balance by bin, etc. No table joins involved.

If you set it up this way, though, you're back to having a database do the job of a spreadsheet.
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)