Query to select records that do not match within a date range

[bezoomnyveshch]

Hi everyone,



This is probably a noob problem but I can't figure it out for the life of me.

I have a customer table with a related purchase table. What I would like to do is to set a date range and find all customers who HAVE NOT made a purchase within that range.

The issue I'm running into is if set up the query to return records between a start and an end date, only those who HAVE made a purchase appear. I can use the "is null" parameter, but that will only give me customers who have never made a purchase.

Does anyone have insight into the best approach for this?

Thanks!

[pbaldy]

Use your query of who HAS made a purchase during the time frame, then use the unmatched query wizard to compare that query against the table of all customers. That will give you who has NOT made a purchase in the time frame.

[bezoomnyveshch]

That seems like a simple solution, thank you! I'll update once I give it a try.

[pbaldy]

No problem, post back if you get stuck.