Multipal Entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with Engineer1 and Engineer2, these are pointing to a
tblEngineer. Having already created a query using a combo, to see which
engineer have attended which "site".

My issue is that when i run the query it only looks at engineer1, how would
i be able to get the query to look in both engineer1 and engineer2.
 
It would have helped if you had provided your current sql. You can normalize
your table by creating a union query like:

SELECT FieldX, FieldY, Fieldetc, Engineer1 as Engineer
FROM tblNoNameGiven
UNION ALL
SELECT FieldX, FieldY, Fieldetc, Engineer2
FROM tblNoNameGiven;

You can then query the union query for a particular engineer or whatever.
 
Back
Top