Showing fields from Primary Keys

[Guest]

Hi,
I am currently making a report booting from a query. The query contains 4
fields
Pink Slip ID; Student ID; Staff ID; Date and time

Wot i need to be able to do, is to do a search by faculty...So i can see how
many pink slips have been issued by that Faculty in the school.

The faculty field, is in the Staff table, With Staff ID as the primary key.
Is there any way Where i can search by the Faculty-Via the Staff ID?!

Thanks

 

[Duane Hookom]

If you create a query that includes the Staff table you can query by
faculty.