Count items

  • Thread starter Thread starter Chrischik
  • Start date Start date
C

Chrischik

Hi,

I have a column in my database with 7 problem types that end users can
select.I need to count them - + create chart to show which is the most common
type.
I am completely new to access 2007 and really need some help building queries.
thanks,
Chris
 
Create a new query based on the table.

Bring down the Problem Type field twice to Field row.

Click on the Query Tools - Design tab.

Click on the ∑ Totals button towards the right side of the ribbon.

Notice that a Group By row is added. Change the second Problem Type column
from Group By to Count.

Run the query.
 
Just one more question,
how do I get the individual property types to show in the pivot chart?
thanks,
Chris
 
Back
Top