Hi I have a query with the following fields
CustomerID
ServiceDate
Rate
WorkorderID
Each customer could have many workorderID (invoices) but I only want the query to show the last serviceDate and no more for each customerId
Thanks Angie
Hi I have a query with the following fields
CustomerID
ServiceDate
Rate
WorkorderID
Each customer could have many workorderID (invoices) but I only want the query to show the last serviceDate and no more for each customerId
Thanks Angie
I am using LAST and it works thanks