Printing different group headings

  • Thread starter Thread starter Chuck Marshall
  • Start date Start date
C

Chuck Marshall

I have a report that groups motel rooms by type, of which there are more
than two.

I want to print the room type in the group header.

Can IIf functions be nested or is there another way to do this for multiple
items?

If possible would like to see a code sample.

Thanks,
Chuck Marshall
 
Yes, you could nest the IIf in a text box to display the
room type in the group header.

You could do something like is in a text box.

=IIf([FIELD]="A","ROOM TYPE A",IIf([FIELD]="B","ROOM TYPE
B",""))

There could be a better way to do this, but this is the
way I usually use.

Josh
 
Back
Top