Count Unique Records

[Berny]

I have a report that has a field that has different values and I want a
summary count of one of those values.

I'm trying to use a text box =count([StatusCode])

What is the syntax for counting status codes of 12

 

[Duane Hookom]

Set your control source to:
=Sum(Abs([StatusCode] = 12))

 

[Berny]

This does not appear to work

What if the code is a text field instead of a numerical field?

I'm getting the following error:

"Aggregate functions are only allowed on output fields of the Record Source"

Set your control source to:
=Sum(Abs([StatusCode] = 12))

--
Duane Hookom
MS Access MVP
--

I have a report that has a field that has different values and I want a
summary count of one of those values.

I'm trying to use a text box =count([StatusCode])

What is the syntax for counting status codes of 12

 

[Duane Hookom]

Is [StatusCode] a field in your report's record source? How would you
determine if the record should be counted or not?

--
Duane Hookom
MS Access MVP

This does not appear to work

What if the code is a text field instead of a numerical field?

I'm getting the following error:

"Aggregate functions are only allowed on output fields of the Record
Source"

Set your control source to:
=Sum(Abs([StatusCode] = 12))

--
Duane Hookom
MS Access MVP
--

I have a report that has a field that has different values and I want a
summary count of one of those values.

I'm trying to use a text box =count([StatusCode])

What is the syntax for counting status codes of 12