Recurrence Report

[dan.cawthorne]

I Want To Create a Report Based of a Query, That Automatically filters
out projects for that week, So i thought i could use the
"RecievedDate" Field.

Is it Easy to do, The Report will be printed every Friday Afternoon
and it shows all the projects from the Monday to that Friday?

How can i do this with out having to type the dates in every week?

Regards


Dan

 

[Steve]

<The Report will be printed every Friday Afternoon>

If this is ALWAYS true, then use the following for your criteria:
Between DateAdd("d",-4,Date()) And Date()

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[dan.cawthorne]

<The Report will be printed every Friday Afternoon>

If this is ALWAYS true, then use the following for your criteria:
Between DateAdd("d",-4,Date()) And Date()

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Thanks Steve, Just the Job, Can i Link that back to the Report so it
shows the Dates ranges?

 

[Steve]

Dan,

Base your report on a query that includes the ReceiveDate and set the
criteria of the ReceiceDate field to what I gave you. Note aghain that this
only works if the Report will ALWAYS be printed every Friday Afternoon

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)