Conditional sum in the report footer.

[mohebk]

Hi,
I am working with MS Access 2003.
I am trying to get a total of a field where the value of another field = to a certain value:
For example this is the report:

Name, Count, State
AAA 5 CA
AAB 4 AZ
AZA 10 CA
ACA 3 CA

I am looking to get a sum of the counts where the state = CA and place it in a text field in the report footer. Is there an easy way to do that?

Thanks

Mo

 

[dhookom]

Try a text box with this expression:

=Sum(Abs([State]="CA") * [Count])

Duane
Hook'D on Access
MS Access MVP

 

[mohebk]

Hi,
I am getting an error that says "Enter Parameter value" Count. I am not sure what is the count for.

Thanks



Mo

 

[MichaelRed]

Count obviously refers to the sample you provided.


MichaelRed

 

[dhookom]

Count and Name are not fit to be used as field names. They are both reserved words and should be replaced with more descriptive names.

Duane
Hook'D on Access
MS Access MVP

 

[mohebk]

Oh, I get it. Thanks a lot.


Mo