I have built several access databases, but I do not write VB. I have edited some VB and made things work for my needs. I get by using multiple queries and canned macros. Things that would make you pros cringe.
I have been working hard to make Allen's example work for me but I just can not get...
I tried to make the example to work for me but I just can't seem to get there.
I am not after an On-hand Balance. The physical inventory we do tells me that.
We bill the customer for the chemical when it is delivered. That part is not a problem and does not need to be handled here.
What I...
I am trying to make a chemical inventory database. The main problem I run into is making the query or queries to calculate usage. We do a physical inventory monthly and receive deliveries during the month. I want to get a starting inventory and add all the deliveries, then subtract the ending...