Making a report pull data from the last week only...

[Jake_Wrestler]

I have a database where our analysts log their time spent on projects. I'd like to be able to run a report that only pulls data from a range starting the day of the report and back 7 days. Any help would be GREATLY appreciated!!!


Thanks.

(Ps. I am a very new user of Access so please K.I.S) :wink:

 

[Joe4]

I don't know if you are running the report off of a Table or a Query. If you are running it from a Table, simply create a query where you add all the records from the Table.

Now that you have a query, under the Date field, enter this under Criteria:
>Date()-7

Now, make sure that your report is using that query as its Control Source.

 

[Jake_Wrestler]

That is awesome, thanks! Of course this makes me think, what if I want to specify a date range that I'd like to run it for, any quick and dirty ways to do this?

 

[Tlewman]

In your query under the date field, enter in the criteria section
Between [Beginning Date] and [Ending Date]

Whenever you run this query, it will prompt you to enter the beginning date and then the ending date and will pull all data between those ranges.