Date query

[geno]

Hi,
I have two tables, one with customer information and the other with dates the customer shopped. What I need is a query that will give me all the customers who haven't shopped for 8 months.
Thanks for any help.

 

[Sohaila Taravati]

In your query where your data field is put this critaria:
<=DateAdd("mmmm",-8,Date())
This looks at 8 months prior to today's date