Conditional Counting Logic & IIF vs IF 1

[3734kumo]

Hope for any help on the following:

If I wanted a count of records based upon a value in an other field, would the statement in the text box look like:

=if xfield = 1 then count(*)

Also, I see both IF and IIF used: what is the difference?

Thanks for any help

 

[VogonPoet]

If is used in VB code:

If A=B then
'some code
Else
'some different code
end if

IIF is the immediate if used in functions:

IIF(A=B,True expression, False expression)

In order to achieve your specific results, you'll need to have a sum in either a report or group footer. The text box should have the following control source (or something like it):

=Sum(iif([xfield]=value,1,0)

 

[3734kumo]

Many thanks to VogonPoet. Someties a very simple answer and example is all that is needed. My grey matter at 70 needs a little stimulous, eventho I have been in the computer field since 1951.

Thanks again.