Date Queries

[Guest]

In my table, I have a date field called Appointment Date which is used in the underlying parameter query
When the user enter a date it should show all dates between 7 to 15 days of the date the user entered
Ex: If the user entered 4/9/2004 it should show all Appointment dates between 4/16/2004 and 4/24/2004
How could I do this

Thanks in advance!!

 

[Rick]

In the criteria for the AppointmentDate field, enter:

[enterdate]+6 And <[enterdate]+16

Before this will work, right-click in the area where your tables are shown.
select "parameters" and enter the following:

Parameter Data Type
enterdate Date/Time



Rick

In my table, I have a date field called Appointment Date which is used in

the underlying parameter query.

When the user enter a date it should show all dates between 7 to 15 days of the date the user entered.
Ex: If the user entered 4/9/2004 it should show all Appointment dates

between 4/16/2004 and 4/24/2004.

 

[John Vinson]

In my table, I have a date field called Appointment Date which is used in the underlying parameter query.
When the user enter a date it should show all dates between 7 to 15 days of the date the user entered.
Ex: If the user entered 4/9/2004 it should show all Appointment dates between 4/16/2004 and 4/24/2004.
How could I do this?

Thanks in advance!!!

BETWEEN DateAdd("d", 7, Date()) AND DateAdd("d", 15, Date())

as a criterion.