![]() |
TOTALING VALUES IN A COLUMN
I have a database that has two columns:
1. Names of children 2. The language the child speaks at home I would like to set up a query that returns the TOTAL number of children that speak EACH language. How could that be done? -- William |
TOTALING VALUES IN A COLUMN
Hi William
place cursor in first cellDataPivot TableFinish On the PT skeleton that appear on the new page, Drag Language from field list to Row Area Drag Language again to the Data area -- Regards Roger Govier "William" wrote in message ... I have a database that has two columns: 1. Names of children 2. The language the child speaks at home I would like to set up a query that returns the TOTAL number of children that speak EACH language. How could that be done? -- William |
All times are GMT +1. The time now is 08:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com