Search results

Hi, I want to make a query where it would first select all records that are newer than [StockTakeDate] and then it should update the [Units In Stock] by taking away [Quantity]. I've googled it and looked hard but unfortunately I can't get this to work. :( Here is what i have done: PLease...

Hi, I want to know how i would get the last date from a table. I've tried 'max', but that just sorts the order of the dates. What i need is for only the last date to be selected. e.g. 24/10/09 27/10/09 - this should be selected 14/05/09 I hope you get what i mean. I'm not too good with...

Hi, Before i start, i just wanna say that i am new to Access & VBA and please excuse me if iask stupid questions. Right here's what i need help with: Basically I have a report which requires the user to type in the OrderID when the user attempts to open the report. This is what pops up...

Hi, I am creating a stock control database. Basically, what I want to happen is the database should contain a database of customers, and all the products the store has. When a sale is made, the stock automatically updates. I have set up all the tables and stuff. PLease could you check it out...