Filtering Access date/time with VB date in SQL

[Ianpbaker]

Hi Romper. I might be wrong but I think your problem is that you have got the date inclosed in Single pips and the # sign, try just using the # sign instead.

"AND (Bookings.Date = '"# & FlightDate & "#)" & _
" AND (Flight Numbers.Departure Time = " & FlightTime & ")"

Hope This Helps

Ian