User Friendly Report: Easy Date Range

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
 
J

James Arnold

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

Between Date() and Date()-14
 

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

Easy Date Range for Report 7
Stored date is not being recognised 1
Report help 8
Date search query 0
Report Query Parameters 2
Query condition by date range 2
Date range in a report 2
Crosstab Query and Date Parameters 10

Top