how to summarize data in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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"?
 
Back
Top