I am in the process of designing on paper a simple inventory database that will track inventory coming in and going out as well as calculating a balance. I am confused as to how to design the part of the table that will actually keep track of the numerical transactions. Do I use two quantity columns and run it like a check book with debits and credits or should I use one column and use positive numbers and negative numbers. My fear is that someone will forget to put in a negative number when they are withdrawing inventory and then the balance will be off. I checked the sample database that comes with Access and they use only one column.
Your thoughts are appreciated.
Bill
Minnesota
Access 2016
__._,_.___
Posted by: "Bill Singer" <Bill.Singer@at-group.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar