View Full Version : weekly query


REDaughdril
10-13-2003, 08:33 PM
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
10-13-2003, 10:16 PM
Presuming the requested date is on a form:

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