Query Customers that havent purchased in the last six months

SpindleMania

Registered User.
Local time
Today, 01:45
Joined
Aug 4, 2006
Messages
13
Hi All,

i have a database that i am trying to clear out old customers that have't bought something in the last 6 months.

i have a table with the customer details in and another table with the purchases in.

i have been using the folowing criteria:

Not Between Date() And #01/05/2007#

but i think this still still shows customers who have actually bought more recent than 01/05/2007.

is there a way to just show customers who have not purchased anything within the last 6 months of the date the query is run on and to only show their last transaction date.

i would really appreciate anyone help, thank you in advance
 
=DateAdd("m",-6,Date()) gives the date 6 months ago.

Chris B
 
Create an aggregate query (click the sigma button on the query design toolbar) based on the transaction table return ing the customer ID and the date and use Max on the date field. This will give you the most recent purchase for each customer. Then you can apply your criterion to the date.
 
wow,

thanks guys that works great, thanks for the quick response, thats cut down the records by about 300 due to people have quite a few purchases

thanks again
 

Users who are viewing this thread

Back
Top Bottom