Search results

Hi, I made 2 simple tables stock Sales where sales-to-stock is many-to-1 with outer join all stocks displayed. I put item A @ 20units into Stock and sell (using autopopulate form) item A @ 5 units now and @ 7 units later. however in the report, instead of recording it as item A...

I did read that before I posted this, but i still don't quite get it. I required to have a stock level for each unique batch no. and DSUM() would not group the sum for each batch no. (CMIIW) and even if it does, it still does not help me with the issue of not updated "Qty" in a combobox display...

Greetings, I am a new member to the access and programming world so do expect nothing much from me :p. I am trying to make, for now, a really simple inventory database for an immediate practical use. I expect my inventory to be of similar items from different suppliers and from different...