Access 2003 Pivot table showing numbers instead of deatils

[Matt Sharples]

Hey,
Although I am relatively new to Access, i have stumbled upon a problem that i did not find in excel (that's first). In excel you can create pivot tables that track a certain number of a particular type in a column. However the Pivot tables in access show you that details of what is in that column.
What I want seemed simple to me. I tried to create a summary query, then use a form to display it in a pivot table. Unfortunetly this didn't work.
Does anyone know how to create pivot tables that display total numbers, rather than details?

Regards,
Matt

 

[JHB]

If you use the QBE grid, in the 3. row of each field you can choose different type of results, like "First", "Max", "Sum" ….

 

[Matt Sharples]

Thanks,
For the sorted ones i used 'Group by' and then i used 'Count.'
I can now track numbers!