IIf Function in Report Footer

[Ron H.]

I have a report where I'm trying to list out last names if a variable in one field is met.

The IIf function statement is as follows in the "report footer" section of the report:

=IIf([Fri1]="ST1",[Last Name],"")



What I'm attempting to get is... If "ST1" is an entry in the [Fri1] field, then list all the last names ([Last Name] is the field of last names) showing a ST1 entry, else "" (don't list anything).

The IIf expression doesn't error out; however, I get nothing listed.

Any suggestions?

Thank You

[June7]

Cannot use calculation in header/footer section to control display of records. You can apply filter criteria in the report RecordSource to retrieve only records where Fri1 <> "ST1".


Header/Footer sections are for aggregate calculations, like:

=Sum(IIf([Fri1]="ST1", 1, 0))

[NTC]

based on my interpretation of your post I can't be sure of your structure - possibly you can achieve what you seek via the OnFormat property of the report's footer section.....right click when your cursor is on the header of the section and then select the OnFormat property; using vba (if/then statement) one can toggle a field's visibility dependent upon another field's value. though I can't tell if that will satisfy your requirement.

[Ron H.]

Thank you both so much.