Help needed urgently!!

[accessistough]

I am creating a database and have ran into a problem I can't seem to fix. Whenever I try to make a query, it says 'type mismatch in expression'. Please could somebody help me!!

 

[accessistough]

It says in SQL view:

SELECT Passenger.PassengerID, Flight.FlightID
FROM Passenger INNER JOIN (Flight INNER JOIN Booking ON Flight.FlightID = Booking.FlightID) ON Passenger.PassengerID = Booking.PassengerID;

 

[ScottGem]

Check the data types of each of your ID fields.

 

[jaydwest]

This can also happen if you do not have your reference library setup correctly. Are you using DAO or ADO? What version of Access are you using? How did you create the database? Is it a new datababase or one converted from an earlier version of Access?