Recent content by member

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...

Thanks wazz ur a star, much appreciated. and also thank you raskew, i didn't use yours cos it seems more complicated and would prefer the one i used. Thanks anyways for ur time.

I can't find 'DMAX' in the list, and when i do type it in, it says that it isn't in the list so i can't select it. I have the 'Totals' Button activated btw. PLease correct me if i am taking the wrong approach. Thanks Steve ( or anyone else)

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...

Sorry KenHigg i didn't understand what you meant, could you give an example. Oh yeh i forgot to mention that the Report loads up from a query: Field: OrderID Table: Invoice Query Sort: Blank Show: Yes Criteria: [Forms]![Sales]![OrderID] Hope that helps

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...