Computer Booking form

[ieuuk]

Hello,

For work i need to create a computer booking form so that people can book out computer rooms 2 weeks in advance and the perminant bookings are always in there etc etc... most of it i have sorted but what i want is for a query that can run and go to todays date and then only bring up the results for the next 2 weeks.

Is there anyone that could help me out with doing this because im at bit of a loss and its doing my head in

Any other comments or suggestions are welcome too if there is a better way of doing this.

Thanks, ieuuk

 

[Treason]

Try using the DateAdd function as criteria under the RentalDate field

Between Now() And DateAdd("d",14,Now())

 

[ieuuk]

excellent... thanks i'll give that a try thankyou. I dont think that i was going to be able to guess that one .

Thanks again

 

[ieuuk]

I have just tried it out and it works perfectly... thank you very much!!