Query-find none entries between two dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ani_unicorn - 01 Feb 2006 15:14 GMT

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

Reply to this Message

BruceS - 02 Feb 2006 05:10 GMT

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
> I have a subform with customer details in.....ie
[quoted text clipped - 11 lines]
> Thanks
> Ani

Reply to this Message

ani-unicorn - 06 Feb 2006 00:30 GMT

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

> Ani,
>
[quoted text clipped - 23 lines]
> > Thanks
> > Ani

Reply to this Message