Date Query

[www.ttdown.com]

I have a database that I need to query. The database contains a
ClientName field and DateofService (MM/DD/YYYY) field. I need to
query the database and return only the Client Names that have some
entries in the DateofService field but don't have a DateofService in
the last 90 days. Can anyone help?

Thanks!

 

[harmony]

Try to put this in the criteria of the dateofservice field:

 

[Harmonyf]

Oops!! I should be:

=(Now())-90

-----Original Message-----
Try to put this in the criteria of the dateofservice field: I
need to
.

 

[John Vinson]

I have a database that I need to query. The database contains a
ClientName field and DateofService (MM/DD/YYYY) field. I need to
query the database and return only the Client Names that have some
entries in the DateofService field but don't have a DateofService in
the last 90 days. Can anyone help?

The format of the DateOfService is irrelevant - that merely controls
how the value is displayed.

You need the rather obscure NOT EXISTS clause in your query:

SELECT * FROM yourtable
WHERE Not Exists(SELECT ClientID FROM yourtable
WHERE DateOfService > DateAdd("d", -90, Date()))