Hi all

I'm trying to select specific data from an Access database but I'm having trouble when using the Access 'date\time' type with the 'date' type in SQL.

This is my code below. FlightDate and FlightTime are VB Date types, Bookings.Date and FlightNumbers.Departure are Date/Time type.

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

The error I receive is "Data type mismatch in criteria expression"

Can anyone help me? Pleeeease....