Filtering a query of one table by info from another table.

[Guest]

I have two tables for a punch clock application, one that holds the employee
names and what department they're in, and one that records each punch in and
punch out. I want a form that displays each punch in and punch out record
for employees in a certian department. My question is how do I filter my
query so that it only shows employees from certain department?

 

[Guest]

Your query must have the field for the dept included in it whether it is
displayed or not ... right? Under the criteria in the query for that field

= xxx

where xxx is the department you want a report for