IIF or something else

  • Thread starter Thread starter 2Blessed4Stress
  • Start date Start date
2

2Blessed4Stress

I have a report where the heading aligns in a heirarchy format. EquipName1,
EquipName2.......through EquipName6. Each of these names may or may not have
their own information for MRF, Model and Type. In my report these items fall
in the detail section.
I'm trying to write an expression that will show the MFR, Model and Type
(seperate fields) for the corresponding EquipName.

ex. Page 1 may read:
EquipName
EquipName2
EquipName3

MRF (would represent EquipName3. It could be blank, in that case show
nothing)

Page 2 may read:
EquipName
EquipName2
EquipName3
EquipName4
MRF (would represent EquipName4. It could be blank, in that case show
nothing)

**I have a headache now, please help in simple language.
 
I figured it out.

=IIf([Lvl6Name]<>"",[Co6],IIf([Lvl5Name]<>"",[Co5],IIf([Lvl4Name]<>"",[Co4],IIf([Lvl3Name]<>"",[Co3],IIf([Lvl2Name]<>"",[Comp2],"")))))

In this case "Co" is the name of the MFR.
Thanks anyway.
 
Back
Top