Date Values

[Guest]

I am creating 4 reports that will return values from a table based on a date
field. One report will be daily I am using date() for that. Another will
return the last 30 days. Another will return 60 and another will return the
last 90 days. Can someone tell me how to write my query so I can return the
values of the last 30, 60 or 90 days? Thanks for your help.

Nick

 

[Rick B]

Between Date()-30 and Date()
Between Date()-60 and Date()
etc.

 

[Guest]

Rick

Thank You very much

Between Date()-30 and Date()
Between Date()-60 and Date()
etc.