How to use query results a criteria within query

[105ben]

I want to return some query result from one table, but then use one of the returned fields as a search criteria to find another field from another table.

SO far I have this

[EIN]![staff]

but the [staff] bit doesn't refer to the staff table, so how do i?

 

[Pat Hartman]

Create a query that joins a table or query to the query that returns the search criteria.

 

[105ben]

OK, cheers! All working now