how to summarize data in table

[Guest]

I have a table in which each field contains duplicate values. I need to
summarize the data based on the values in one of the fields, like this:

Fields: item, brand, size, type, formula

summay:

type1 #of items, #of brands, #of sizes, #of formulas
type2
type3

How can I do this?

 

[Guest]

Use a Totals or Summation query and count each.

 

[Guest]

SELECT COUNT(*) WHERE TYPE = 1

 

[Guest]

Would this give me rows with the type as a row heading, and columns with
counts underneath? And where do I put the source table names? Is it like
this: "select [field] from

where count [type] = 1"?