dates in access query 2

[jazz007]

I have a table and the field in called startdate

What I want to to show all records of people before 90 days and before todays date. basically today is 19/05/05 I want all records before 90 days ie 19/02/05 when ever i run the query. so i dont want the query to pick up the last 3 months ie 90 days of data to be shown.

I have tried the following
Between (now() -90)and now()
but this only shows the data from todays date to the last 90 days worth of data.
What i require is data from the start less than the last 90 days from todays date.

Any solutions for this

 

[RoyVidar]

Would

[tt]<now()-90[/tt]

Work

Roy-Vidar

 

[PHV]

<DateAdd("m",-3,Date)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jazz007]

thanks guys it all seems to work when using
<now()-90

that brilliant and thanks for the quick response