count/sum function

[Sham]

Hello!
i am trying to sum the total of ID's by corporate titles in query. In the totals row i have selected 'count' in the ID column and 'sum' in the title column but this doesn't work. I tried the reverse and it also was no good

Can anyone help - i'm sure its something simple
thanks

 

[Brianwarnock]

Try Groupby in the Titles and Count in the Id

 

[Sham]

Brian - it still doesn't work.
I have other fields in my query - could this be the problem?

 

[boblarson]

Brian - it still doesn't work.
I have other fields in my query - could this be the problem?

Yes, if you want the count of corporate ID's then just include the ID and select Count.

 

[Sham]

Boblarson - thanks but i want to count the number of IDs by title

 

[boblarson]

Then put the title in first and have "Group" selected and select ID's and select Count for that one.

 

[Sham]

Thanks - that worked!

 

[Brianwarnock]

Try Groupby in the Titles and Count in the Id

I know I'm not as bright as you younguns but I have one advantage, I read the posts.

Brian