Mailing labels for customers a year old

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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.
 
Back
Top