Rolling 90 day lookup Querie

[Buddus]

I have a data base that has 1500+ dated records. In a Query I am looking for a way to enter a date and from that date look for every entry from said date to the previous 90 days. So if I enter 8/1/11 it would return every record between 5/1/11 through 8/1/11. I have tried the following with no avail:



>=[date]-"90" (knew this one would return more than what I am asking for above)

Between [date] And [date]-"90"

Access is returning "expression is typed incorrectly or it is too complex to be evaluated."

Thanks

Buddus

[orange]

Research the DateDiff() function

http://www.techonthenet.com/access/f...e/datediff.php