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
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