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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report help 8
Easy Date Range for Report 7
Stored date is not being recognised 1
Report Help 1
value on a specific date 3
Problem with date criteria in Query 2
Creating report with date counts 1
Making a mail merge from a query 2

Back
Top