Rolling dates.

[Floyd Forbes]

Hi , I have a query base on a table with a vacation field and a date field.
If I'm starting
vacation 1/24/2005 how could I put in the next four days by using a query?
Instead of
typing the next fours days, can I automatically input the next four days
pressing 4 in a
query?

Floyd

 

[John Vinson]

Hi , I have a query base on a table with a vacation field and a date field.
If I'm starting
vacation 1/24/2005 how could I put in the next four days by using a query?
Instead of
typing the next fours days, can I automatically input the next four days
pressing 4 in a
query?

Floyd

Try

BETWEEN [Enter start date:] AND DateAdd("d", [Length of vacation:],
[Enter start date:])

John W. Vinson[MVP]