Multiple criteria in one query

[Os]

I have two boxes on a Form "Access 97" that store data
for "picker" and "loader" respectively. When I run my
Excel pivot table report that pulls data from Access, I
was able to show percentage for cases picked in one
report and percentage for cases loaded in another pivot
table report. But to measure employees performance we
have to combine the two percentages "manually" to get the
final number! Is there a way to combine both numbers for
the same individual in one report.

Each employee can be a picker or loader at any given
time. Currently when I run the "picker" report I will
show any picker and all those who loaded with him/her.
Same goes when I run the "loader" report. But I'm having
a little of a problem combining both together.

Any help is highly appreciated.

Thanks.

 

[[MVP] S.Clark]

Without knowledge of the table structures, or the SQL, it's not possible to
offer a solution.