Calculated fields in a report

[mariaw]

Hello

I have the following calculation in a text box on my report:

=IIf([Undef/Def]="u",Count([Undef/Def]))

What I am trying to do is ask the computer to count the records, but only if the character entered in the Undef/Def field is "u" - but it doesn't like it - it just counts them all.....

Any suggestions of how to reword the calculation?

Thanks!

Maria

 

[Brianwarnock]

I think you have to do it this way

=Sum(IIF([Undef/Def]="u",1,0)

Brian

 

[boblarson]

Also, on an unrelated matter - Do NOT use reserved characters in field names. Characters such as "/" or "#" are frequently used by people in field names, but this will eventually cause you problems. If you can do it, rename them now to avoid problems. You can do a search about these and find many people who have suffered badly due to the use of those characters. It can bite you especially when you are trying to use formulas in forms and reports, as well as other times such as VBA code.

 

[Brianwarnock]

Thanks Bob, I actually meant to mention it as it confused me when trying to understand the problem, but "she who must be obeyed" called as I was typing and it slipped my mind.

Brian

 

[mariaw]

To Brian Warnock

Thank You It Has Worked!!