User Friendly Report: Easy Date Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have created a report based off of a query. The report will be printed
for specific records within the last two weeks of the current date. Is there
a way to design the query so that it only shows records for the last two
weeks from the current date? I do not want my users to go into the Query
Design view to change the date range every two weeks.

Any alternative solution would also be appreciated.

Thank you!

Diana
 
For the date field of the query, enter the following in the criteria:

Between Date() and Date()-14
 
Back
Top