Sum of each of three posibilites for one field

[SgtJarrow]

I have a report that contains a field [Type]. There are three possibilities for this field - N, C, or U. I need to get a count for each of these possibilites per group of the report. I have searched the forums, and found some close but I can get nothing to work....any help????

Example:
Group1:
U
U
C
N
U-Total: 2
C-Total: 1
N-Total: 1

Group2:
N
N
C
U
U-Total: 1
C-Total: 1
N-Total: 2

Thanks a lot. "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." Albert Einstein.

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com

 

[kb178]

I usually use DCount for things like this. Create a textbox in the report and put (this would assume your grouping level is by month):
=Dcount("ID","mytable","[Type]=U And [Month]=Reports!report!month&quot
=Dcount("ID","mytable","[Type]=N And [Month]=Reports!report!month&quot
=Dcount("ID","mytable","[Type]=C And [Month]=Reports!report!month&quot

 

[SgtJarrow]

Yeah, I would normally use DCount for this too....But it gives me an #Error.....Here's the exact info....

Table
tblVariance

Report
rptVariance

Group
Country (Argentina, Brazil, etc.)

Details
BaseNumber
BaseName
Type (New, Closed, Updated)
SKNumber
SKName

I need to be able to show the number of new, closed, and updated records per country. DCount should do the trick but for some reason it is not. There is no query as this is the only report for this table and there is no need to filter any of the data. I'm stumped.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." Albert Einstein.

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com