Count Unique Records

  • Thread starter Thread starter Berny
  • Start date Start date
B

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
 
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"

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

--
Duane Hookom
MS Access MVP
--

Berny said:
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
Click to expand...
Click to expand...
 
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


Berny said:
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"

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

--
Duane Hookom
MS Access MVP
--

Berny said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top