G
Guest
Hi. I have an Access 2000 database with two tables (customers and sales). The
table "sales" contains a field (CustomerID) which is linked to the CustomerID
in the "customers" table. I want to create a query where I get a list of all
my last sales for each customer. The way I currently do this is sort the
"sales table" by "CustomerID" and then "sales date", copy to Excel and then
manually delete everything except the last sale for each customer. Does
anyone know how to do this using an access query? I appreciate any help!!!
Thanks!
table "sales" contains a field (CustomerID) which is linked to the CustomerID
in the "customers" table. I want to create a query where I get a list of all
my last sales for each customer. The way I currently do this is sort the
"sales table" by "CustomerID" and then "sales date", copy to Excel and then
manually delete everything except the last sale for each customer. Does
anyone know how to do this using an access query? I appreciate any help!!!
Thanks!