Do aggregate functions work properly in 'Group by' queries?

[JHSam]

For some reason I can't get the DCount aggregate function to work properly in a Group By query. I'm trying to get the counts of different responses grouped by location. The expression looks something like this:

CountPos: Count("[Cond]","<sourcedata>","[Cond]='Pos'")

The problem is that it is not propertly grouping the counts, but instead returns the (same) total number of counts for the 'Pos' in the [Cond] field for both groups.

Any thoughts on resolving this would be appreciated.

 

[Norie]

Why are you using Dcount? Why not add [Cond] twice set one to Group By and one to Count.

 

[JHSam]

Re: Do aggregate functions work properly in 'Group by' queri

The simplest approach always works the best ... thanks for the reply - it works fine now.