counting text selections

[Agartha]

I have a table with four columns, each textural - boiler type, insulation type, build type, survey type. Of each coumn there are only a handful of options to select e.g five types of boiiler etc, 6 types of insulation etc. I'm trying to build a query whereby these data are summarised thus: Numbers of each boiler type, numbers of each insulation type etc. I've been messin around with 'counts' and 'sums' but my ultra-novice skills are lame here. Help!

 

[statsman]

Try using expressions in your query. To count for boiler type 1 add to your query:

Boiler1:Count[boilertype]


Change the "Group By" to "Expression"
Enter =1 in the criteria

 

[Agartha]

Thanks very much for your help. I still can't manage to get the thing to execute. Regards: 'Boiler1:Count[boilertype]'

- I am using column header 'boilertype' for what is bracketed here
- I am using a particular boiler type text for what you have written as 'Boiler1'
- I am using the same particular boiler type text in my criteria e.g. ="combination"

e.g in all I have: combination:Count[boilertype]

when I try run the query I get the mesage: 'does not include specific experssion 'BoilerType' as part of agrearate function'