Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Greydaddy
-
SQL query date between for booking dates
yes, you are both right! Many thanks william for reminding me of enclosing with ( ), mmmmm simple things eh ;) Cheers both, Dave- Greydaddy
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
SQL query date between for booking dates
Hi Paul, Thanks for your help, but no joy. I have have filtered each BETWEEN for the room number and it works, seems abit long winded but is all in one query as follows. Set RsDatecheck = conn.execute("Select RoomNumber, Arrival, RoomAvailable From CustomerRoomBooking where " _ &...- Greydaddy
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
SQL query date between for booking dates
I am trying to select arrival dates and departure date to find a match between alredy booked dates from a database. The query is this: Select Arrival, Departure from RoomBooking where Arrival between vararrival and vardeparture OR Departure Between vararrival and vardeparture AND vardeparture...- Greydaddy
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
