Hello, I'm having trouble running reports based on specific criteria in my application:

      Form (A) collects different Job Types (Help Desk, Services, Development, etc).

      Form (B) collects Employee Info including Name and Job Type (using a lookup to Form A)

      Form (C) assigns Office Equipment to different employees

I need to run 2 reports on Form (C). The first is a pivot table, and the second is standard report. However, these reports must be limited to employees of just 1 Job Type. How do I set the criteria / filter these reports so they only show the Equipment owned by Services employees (for example).

Thank You for any assistance!
Lars