count & iif howto??

jani78

New member
Local time
Today, 03:10
Joined
Feb 2, 2008
Messages
3
Hi guys,
I would like to count how many "3" numbers are in a query column, and the result see in a report.

I try this expression in the report:
=IIf([mezo11]=3;Count([mezo11]))

and
=Count(IIf([mezo11]="3",0))

but don't work
 
Last edited:
thx, but don't work..
I don't understand why..
I can't able to write to the expression row this: =Count(IIf([mezo11]="3",0))

Error message:
"Invalaid syntax in the expression ..
 
If three is a number and not text remove the quotes surrounding it
 
That was my fauly also - "" is for text I wasnt thinking.
 

Users who are viewing this thread

Back
Top Bottom