Rolling dates.

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

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
 
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
Click to expand...

Try

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

John W. Vinson[MVP]
 
Back
Top