just want rows with the date that is 90+ days in the pass - 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

 

[Remou]

Leave out the delimiters.

SELECT * FROM Table WHERE DateField< Date()-90

http://lessthandot.com

 

[SkipVought]

hi,

The # delimiters converts a STRING to a DATE. If you already have a DATE, then you do not need to convert anything.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[techexpressinc]

Works Great Thx Russ