Query-find none entries between two dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a subform with customer details in.....ie
'date product sent', 'product name', 'price' and a few other details. What
I need to be able to do is to track clients who do not have a product sent in
the previous month, in order to keep on top of my forward planning for sales.
ie those that have not had a product say within January by the end of
Febuary could then be sent special offers etc.
Is there a way to put a query in to find those who have not had a product
between eg 1-1-06 and 31-1-06 when there is no entry on the date or product
name. I cant seem to find a way of querying none entries.
Or is the only way to do this is to actually update the date sent for all
clients whenever a product is sent out but mark say the product type as 'nul'?
Any help or advice would be appreciated.
Thanks
Ani
 
Ani,

Start with a query of those clients who DID order during January. Use those
results in an "unmatched" query of all clients who were entered into the
database before January.

For help creating the unmatched records query, go to the list of queries in
the database window, click "New", and then select "Find Unmatched Query
Wizard". It will walk you through the process.

Bruce
 
Hi Bruce
apologies for not replying sooner! I have only just had chance to check if
I had any answers. Brilliant, Thanks very much, it works bueatifully!
Cheers
Andrea
 
Back
Top