Access Queries - date help needed


FH is my second home
Dec 23, 2003
I need to specify a date, and then take all the dates from that day, and the following week.

I can do it from todays date easily enough

"Between Date() And (Date()+7)"

If I replace date() with [Please Enter Date], I can get the user input, but how do I add 7 days on to that?

I need to refer to the previous date entered, but I have no clue about how to do it

Any ideas?

Users who are viewing this thread

Top Bottom