Date function in a query

[Guest]

I hope this is easy...Have a form with 3 list boxes...an appointment database

First listbox is based on a perimeter query Date() in the appointment date
field.
This lists my appointments for today.

2nd listbox is based on a perimeter query Date()+1 which lists appointments
for tomorrow.

3rd listbox is where I am having the problem with the syntax in the query
How do I return the query which would list from the day after tomorrow for
two weeks. Date() (unkown syntax)

I hope this is easy, thanks

 

[strive4peace]

between (Date()+2) and (Date()+14)

you can also do this:

= (Date()+2) and <=(Date()+14)

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Thanks, I was close at one time of getting it and thought I had to use the
between

 

[strive4peace]

you're welcome, Brian happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*