R
redstamp
Can someone please tell me how to force access to extract unique
records, based on the last record in a particular field.
Basically I have a customer table linked to a customer_order table. I
want to query through access fields within the customer and
customer_order table, but only extract their most recent order to the
results, therefore ending up with a unique list of customers with last
order details only.
I realise you can set unique records and values in a query, but this
still retrieves multiple lines if the data is different in the order
details. I want to force unique customer records, based on the order
date.
Any help is gratefully received.
Thx
Jon
records, based on the last record in a particular field.
Basically I have a customer table linked to a customer_order table. I
want to query through access fields within the customer and
customer_order table, but only extract their most recent order to the
results, therefore ending up with a unique list of customers with last
order details only.
I realise you can set unique records and values in a query, but this
still retrieves multiple lines if the data is different in the order
details. I want to force unique customer records, based on the order
date.
Any help is gratefully received.
Thx
Jon