JimmyG
Registered User.
- Local time
- Today, 05:35
- Joined
- Aug 3, 2004
- Messages
- 37
My database contains, amongst other items, a companies form and a orders form. I have a field on my order form to insert the order date. On the Customers form I have a filed called date last ordered.
I need to be able to fill the date last ordered field with the most recent date from the orders form (some customers order several items each week). I have attempted this using an update query, the query returns a date which is correct for the customer but isn't necessarily the most recent date. The problem only seems to occur with customers who make lots of orders.
How can I make the update query return the most recent record?
If it helps, each order has an order number, the most recent date,i.e the one I want will therefore have the highest order number
Does anyone know what I am doing wrong?
I need to be able to fill the date last ordered field with the most recent date from the orders form (some customers order several items each week). I have attempted this using an update query, the query returns a date which is correct for the customer but isn't necessarily the most recent date. The problem only seems to occur with customers who make lots of orders.
How can I make the update query return the most recent record?
If it helps, each order has an order number, the most recent date,i.e the one I want will therefore have the highest order number
Does anyone know what I am doing wrong?