Crosstab Breakdown

I

Iram

Hello. I am using Access 2000 and I have a query with about 20 fields but
what I want to know is how do you go into a regular Select Query and change
it into a query or something that will give me totals for certain fields.
Could you give me in laymans terms what row headings and column headings and
value fields are? I am confused on how to do this.

Thanks.
Iram/mcp
 
K

KARL DEWEY

how do you go into a regular Select Query and change it into a query or
something that will give me totals for certain fields.

Open the query in design view and click on the icon that looks like a Greek
"E" (Epsilon) and it will change your query to a totals query. Change the
Group By to Sum for those fields you want to total.
 
Top