Date issue for calander

[DaniBoy]

Hello,
I am trying to make a query where it will give me the following resutls:

I have a form where I have a Delivery Date. The user needs to be able to check what the delivery schedule is for the next two weeks. This way they can decide when they can deliver the product to the customer. I am thinking of having a botton that will run this query. This query will have all delivery dates available from "Todays Date" into two weeks from now. On the query in the field deliveryDate I will have a criteria that somehow only will show all delivery dates between todays date and 2 weeks into the future. How do I set it so it does that?

I tried between Date() and Date()+14

But that didnt work.

Please Help
Daniboy

 

[yippie_ky_yay]

How about something like:
SELECT tblDates.*
FROM tblDates
WHERE (tblDates.date>=Format(Now(),"dd mm yyyy")) And (tblDates.date<DateAdd("d",14,Now()));

I'm sure you could improve on how to get the current date - but this should be a good start.

-Sean