Report with a specific criteria

[augcorv@gmail.com]

Can anyone tell me how to set a specific criteria in a query using expression builder to have a report show record dates from 3 days prior and 2 days in the future? Ive tried setting DateValue with no success.

[pbaldy]

You'd want DateAdd(), but this may work:

Between Date()-3 And Date()+2

[augcorv@gmail.com]

Thank you once again pbaldy. Also found this Microsoft link which is very helpful.

http://office.microsoft.com/en-us/ac...010341674.aspx

[pbaldy]

No problem.