date help - pull records 90 days in the past how?

[techexpressinc]

I am trying to create a simple querry in ms access to pull rows from a table with dates in the record where the date is are over 90 days behind the date of the current date.

I tried = "<#Date()-90#" without success.


Thank you for any input Russ @ scaninc.org

 

[MSAccessRookie]

I am trying to create a simple querry in ms access to pull rows from a table with dates in the record where the date is are over 90 days behind the date of the current date.

I tried = "<#Date()-90#" without success.


Thank you for any input Russ @ scaninc.org

The hash marks ("#") are used when converting strings to dates. Date() is a built in access Function that does not require them.

=date()-90

 

[techexpressinc]

Thanks I got it working with putting this in the criteria box <Date()-90

 

[techexpressinc]

Thanks - I have it working with this in the criteria box "<Date()-90" Russ