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

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

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?
 
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
 
Back
Top