If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IIF or something else
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. |
#2
|
|||
|
|||
IIF or something else
You did not say what your table structure was.
-- KARL DEWEY Build a little - Test a little "2Blessed4Stress" wrote: 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. |
#3
|
|||
|
|||
IIF or something else
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. "KARL DEWEY" wrote: You did not say what your table structure was. -- KARL DEWEY Build a little - Test a little "2Blessed4Stress" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|