Q:

Query Compare to Find Matches

I have two queries in MS Access.  One has a field labeled "Assembly" and the other query has it's field labeled "Assemblies". 
I need to compare the two queries (both with only the one column) and find out from the query with the "Assemblies" column which entries MATCH the other query.
Thanks

A:

To find the matching records, a simple inner join will suffice here, e.g.:
select * from query1 inner join query2 on query1.assembly = query2.assemblies

Rename query1 & query2 as appropriate.

