Formula in Report or Query

Topic

New Reply

Hi, I am struggling with the syntax for forumla. In a table I have a combo, say X with options of A, B or C. I need, either in my query or report, to do a count of X where number of records = A, if not A then 0. How would I construct this, I have been playing with:

=iif([qryName![X]=”A”,count([X]),0) but this isn’t liked.

Thanks, Darren.

Reply | Quote

Replies

Try

=Abs(Sum([X]=”A”))

[X]=”A” is either True = -1 or False = 0. So the sum counts all occurrences of “A” as -1. The Abs (absolute value) function removes the minus sign.

Reply | Quote

Sweet Hans, thank you.

Reply | Quote