Hello everyone, I wonder if you can help me please.

I have a DB which logs items, and it is used by many different people.
For example, in one day :
Joe Bloggs may log 32 items against 4 different areas.
Fred Bloggs may log 54 different items against the same 4 areas.
and so on.

My question is, what would be the best way to get a report to show the following :

Joe Bloggs =>
Area 1 Items = 10
Area 2 Items = 14
Area 3 Items = 6
Area 4 Items = 2

Fred Bloggs =>
Area 1 items = 22

And so on....

I've been advised that a Pivot Table would be the best way to go, so I've created this.

However, it runs for everyone whereas I only want it to run for the area I select from a combo box on a form.

Does anyone know how I would do this ?

I'd appreciate any help you can offer.

Thank you.

Albert.