Personally, I would put clear labels as to the quantity coming in and going out and do the subtraction yourself without relying on them to use a negative.
If they did, I'd take the absolute value before the subtraction.
Respectfully,
[RCEmailSigLogo]
Liz Ravenwood
Software Engineer
Interior Systems
(520) 239-4808
Liz_ravenwood@beaerospace.com<mailto:Liz_ravenwood@beaerospace.com>
rockwellcollins.com<http://www.rockwellcollins.com/>
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, May 25, 2017 9:56 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Table approach for Inventory database
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
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
[Non-text portions of this message have been removed]
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar