Mailing labels for customers a year old

[Jim]

I have a database for a carpet cleaning business. I want
to be able to send out, on a monthly basis, reminder cards
reminding customers it has been 12 months since their
carpets have been cleaned. I can build a query to find out
who I serviced in Aug 2003(for example). But that list
will include names of customers I have serviced more
recently. Plus it may also include a name twice if I
serviced them twice in one month. How do I narrow down the
Aug 2003 list to not include duplicates or those I have
serviced more recently? Thanks

 

[Jeff Boyce]

Jim

From your description it sounds like you want to select those customers
whose Max() DateOfService is more than a year.

Consider using a Totals query, grouping on the customerID and finding the
Max() on the service date field.