Code Question

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a table with a few different columns, the 3 of
value for this question are

Employee ID Reviewed ActiveStatus


as background the Employee ID will be for one employee and
they will be reviewing another employee (Reviewed)and
ActiveStatus is located in another table. is there anyway
to check the EmpID and access all people he 'Reviewed' but
only if the person Reviewed has a certain ActiveStatus?

THANKS A BUNCH
 
I have a table with a few different columns, the 3 of
value for this question are

Employee ID Reviewed ActiveStatus


as background the Employee ID will be for one employee and
they will be reviewing another employee (Reviewed)and
ActiveStatus is located in another table. is there anyway
to check the EmpID and access all people he 'Reviewed' but
only if the person Reviewed has a certain ActiveStatus?

THANKS A BUNCH
Click to expand...

No "code" is needed. A very simple Query will do the job. Create a
Query joining the two tables (by joining Reviewed to the table
containing ActiveStatus, joining to EmpID) and put a criterion on the
ActiveStatus field.
 
Back
Top