report confined to the last 7 days ?

[primerov]

I have a report that shows the daily reports of the calls made
by our dealers. In the Sorting and Grouping section of the report
i have CallDate set on perDay. In the field CallDateHeader
of the report i have the following expression :

=Format$([CallDate];"Long Date";0;0)


The above reports shows all the records of the calls. Is it possible
to make the report showing always the prevous 7 days and not all

the records.So, i imagine, to substract the present date with 7 and
thus confine the report to the last 7 days ?

 

[CosmoKramer]

If the RecordSource of your report is a table:

In design view under report properties set the Filter property to:

CallDate Between Date() and Date()-7

and make sure that Filter On is set to Yes

If the RecordSource of your report is a query:

Add the following to the criteria box for the CallDate field:

Between Date() And Date()-7