weekly query

[REDaughdril]

I have a query that has [date],[employee],[start time], [end time],[total time]

I need a criteria that will give me a report for the week that starts with the date requested when the query starts.

Thanks

 

[pbaldy]

Presuming the requested date is on a form:

Between [Forms]![FormName]![DateField] And DateAdd("d",7,[Forms]![FormName]![DateField])