7 Days from date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a like Query that the user puts in a date. I would like the date to be
the start date for a week. How can I make it so that the Query will show 7
days of data. So if the user puts in 1 Nov 04 it will show all records from 1
- 7 Nov 04. Can I do this and if so how?

Thanks any help would be great.
 
I have a like Query that the user puts in a date. I would like the date to be
the start date for a week. How can I make it so that the Query will show 7
days of data. So if the user puts in 1 Nov 04 it will show all records from 1
- 7 Nov 04. Can I do this and if so how?

Thanks any help would be great.
Click to expand...

As criteria on the date field:

Between [Enter Date] and [Enter Date] + 7

You must also enter the [Enter Date] parameter (and it's datatype) in
the Parameters dialog box.
In query design view, click Query + Parameters
Write:

[Enter Date] Date/Time

in the dialog. Save the dialog.

Note: the dates must be entered in U.S. date format Month Day Year,
regardless of your regional settings.
 
Back
Top