Last Service Date

[Guest]

I am trying to run a query that will give me the last date that each of our
customers were serviced. From this I can schedule future services.

Ex. Customer "Smith" was serviced on 1/2/05 1/9/05 and 1/16/05
Customer "Jones" was servied on 1/4/05 and 1/10/05

I want to pull up the records of only Smith 1/16/05 and Jones 1/10/05

Each customer has a schedule interval that could be different, so I am
trying to be able to run a query of customers that are due.

Thank you for your help
Curt W

 

[Allen Browne]

1. Create a query into your service table.

2. Depress the Total button on the toolbar (upper sigma icon).
Access adds a Total row to the grid.

3. Drag CustomerID into the grid.
In the Total row, accept Group By under this field.

4. Drag the ServiceDate field into the grid.
In the Total row under this field, choose Max.

This gives one row for each customer, with the most recent date beside each
one.

If you want more alternative solutions, see:
http://www.mvps.org/access/queries/qry0020.htm