Hey All

Can anyone tell me whats wrong with this:

strSQL = "SELECT tbl_History.*, Employees.*, tbl_Vehicles.* FROM tbl_History INNER JOIN Employees ON (tbl_History.EID = Employees.Employee_ID) INNER JOIN tbl_Vehicles ON (tbl_history.VID = tbl_Vehicles.Vehicle) WHERE tbl_History.EID = " & eid & ""

It returns no records when there is a record it should be returning.

I have a feelign it's because of the WHERE statement.
What i want it to be doing is Joining the 3 tables.
Showing records that match the EID from the History table.

ideas
cheers
b