Recent content by aerozeppel

Thanks Uncle Gizmo, I use an android inventory app to record stock levels which I can then export to a spreadsheet and then into access. I may be able to automate that part at some other time but it's not important to me right now. It's a way to do the calculation that I'm stumped with :(

If only I could do it that way. I wanna create this database for a small pub that I work in, it has a pretty basic till, there's no way to log sales. I count the stock every week and currently use excel spreadsheets to log these stock checks, work out avg usage over a period and then recommend...

The query result should probably have a date field in it as well :/ ProductID UsedDate UsedAmount 1----------26/08/17------1-----------(=3-2) 2----------26/08/17------2-----------(=3-1)

Thanks for your reply. I won't have any invoice type table as there is no record of stock going out other than comparing the latest stock take with the previous stock take I can do the following calculation: stock used = previous stock - current stock + stock acquired. Which is why I asked if...

So I have this table to store quantities after each time a stock check is done and am trying to create a query that for each product would do the calculation (previous stock check quantity) - (latest stock check quantity) my tables are laid out as follows: StockCheckID StockCheckDate ProductID...