Multipal Entries

[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.

 

[Duane Hookom]

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.