By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,730 Members | 1,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,730 IT Pros & Developers. It's quick & easy.

SQL query in

P: n/a

Im new to and am trying to create my first
practice project. The problem iv encountered is to do
with SQL queries issued against my access DB iv created.
i want to wright a query that will pull all the caravan
details that are available at a partuclar date which will
be entered by the user. The query will have to ensure
that the caravans are not booked by another guest for
that specifed date period. the 3 tables i need are:

Guest Info table:
Booking No (PK)
Date of Arrival
Date of Departure

Caravan Booking table:
Caravan model No (PK, FK)
Booking No (PK, FK)

Caravan details table:
Caravan model No (PK)
Beds in caravan.

Can anyone help me with this query? How do i include the
dates that the user enters on my interface using the
DateTimePicker control into this query?

thx for your time. :o)
Nov 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.