A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

IIF or something else



 
 
Thread Tools Display Modes
  #1  
Old March 25th, 2008, 09:26 PM posted to microsoft.public.access.reports
2Blessed4Stress
external usenet poster
 
Posts: 30
Default 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  
Old March 25th, 2008, 11:31 PM posted to microsoft.public.access.reports
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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  
Old March 26th, 2008, 04:47 PM posted to microsoft.public.access.reports
2Blessed4Stress
external usenet poster
 
Posts: 30
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.