Access 2003

[beebobs]

I have added the first fine I wanting to bring the MO ENGINEERING, form my
query the MO Material field was null.. this works fine

MO: IIf(IsNull([MO MATERIAL]) & " " & [MO MATERIAL],[MO ENGINEERING])

Now I am wanting to pull in the MO Construction filed if the field in the
NAME Column= IPS. When I add this it brings back a -1 value..

And IIf([NAME]="IPS",[MO CONSTRUCTION])

Any suggestions?

Thanks
beebobs

 

[Ken Snell \(MVP\)]

You need to use nested IIf expressions:

MO: IIf(IsNull([MO MATERIAL]) & " " & [MO MATERIAL],[,[MO ENGINEERING],
IIf([NAME]="IPS",[MO CONSTRUCTION], "No Result Found"))

 

[John Spencer (MVP)]

Perhaps you should tell us what you are attempting to do in words.
This expression is not understandable.

MO: IIf(IsNull([MO MATERIAL]) & " " & [MO MATERIAL],[MO ENGINEERING])

Perhaps you want to return Mo Material is it is not null or if it is not ""
and otherwise return Mo Engineering.

MO: IIF(Len([Mo Material] & "") > 0, [MO Material],[Mo Engineering])

The next part is more confusing, but perhaps you mean you want
Mo Construction if some field ?Name? = IPS
And if Not then Mo Material if it is not blank or null
and final choice is Mo Engineering.

MO: IIF([Name] = "IPS",[MO Construction], IIF(Len([Mo Material] & "") > 0, [MO
Material],[Mo Engineering]))


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Ken Snell \(MVP\)]

Typo in expression:

MO: IIf(IsNull([MO MATERIAL]) & " " & [MO MATERIAL],[MO ENGINEERING],
IIf([NAME]="IPS",[MO CONSTRUCTION], "No Result Found"))

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

You need to use nested IIf expressions:

MO: IIf(IsNull([MO MATERIAL]) & " " & [MO MATERIAL],[,[MO ENGINEERING],
IIf([NAME]="IPS",[MO CONSTRUCTION], "No Result Found"))

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

I have added the first fine I wanting to bring the MO ENGINEERING, form
my
query the MO Material field was null.. this works fine

MO: IIf(IsNull([MO MATERIAL]) & " " & [MO MATERIAL],[MO ENGINEERING])

Now I am wanting to pull in the MO Construction filed if the field in the
NAME Column= IPS. When I add this it brings back a -1 value..

And IIf([NAME]="IPS",[MO CONSTRUCTION])

Any suggestions?

Thanks
beebobs