7 Days from date

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.

On Sat, 13 Nov 2004 15:33:01 -0800, KAnoe wrote:

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.

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.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.