Date range in a query

[Wrecker]

If I put...[Todays date?]in the criteria of a field, access prompts me to input the date, and returns the data from the Query, for the date I specified. How would I input the dates to return a weeks worth of data?

Thanks
Paul

 

[JoeMiller]

Between [Start Date] and [End Date]

or if you're always going to look at today's date - 7 you can use this:

Between DateAdd("d",-7,Date()) and Date() Joe Miller
joe.miller@flotech.net