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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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
  2. Greydaddy

    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 " _ &...
  3. Greydaddy

    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...

Part and Inventory Search

Back
Top