Recent content by matt925

Hi there, Since I uploaded the database I have managed to get a query working for it. Only thing is.. it deducts the (QUANTITY x HOW MANY TIMES THAT DVD APPEARS ON THE RENTAL TABLE) Any ideas anyone? So confusing!! Help Much appreciated

Hi, I'm using Access 2007. Attached a copy

Hi, FAIRLY new to all this. I'm having a little trouble figuring out how to update the stock levels for items in my stock table. It is a DVD Rental Database, so of course I need stock to be subtracted and added back on. I already have a query for the amount of stock for each item, however, this...