Alright Access Gurus... I am trying to iron out the LAST problem with this db I am working on for tracking inventory and issue of equipment through my office. now that I am THIS CLOSE, I seem to be running into the biggest problem of them all with trying to track totals of each item I have in the office.
I have a form (frmAssign) that is related to a query(qryAssign) and a table (tblAssign) sorry for the lack of imagination. the purpose of all of these is to allow me to -you guessed it- ASSIGN equipment to each employee. I have a table called tblProducts that lists the products, etc that I issue to them, as well as the total number of each item that I currently have in stock in the office.
when the equipment is issued, I would enter the item and quantity being issued in a control (quantAssign) on frmAssign, and when I hit the button, the number I have just assigned to them NEEDS to be subtracted -somehow- from the total quantity (on tblProducts) so that when the next dude comes in, I can see at a glance the TRUE quantity that I have in stock.
I understand not wanting to truly SUBTRACT that assigned quantity from the total (especially because for all intents and purposes, the equipment is not "DISAPEARING" as much as it is just being MOVED temporarily... I will most likely get it back at some point and new equipment will be issued).
I light of this, it seems that I need to use some kind of DSum() or something to total each item then subtract from the overall quantity and use the result as my new quantity, but I am absolutely lost as to the best way to do it.
Thanks for the help, and let me apologize in advance for what you are about to get yourself into
Mike