same fields in a report - use IIF to change 1

krberube

just beyond new
Local time
Today, 12:01
Joined
Jan 14, 2005
Messages
142
Good Morning all,
I have a report that I have field called "MBModel". this show up on one place.
I want to use that same field somewhere else but have it show something different (If that makes sense)

I was thinking on the second field to use =IIF([MBModel] = MB06042, "VIA C3")

Its not working correctly.

Can anyone help with this one?
Kevin
 
Try this.....

=IIF([MBModel] = "MB06042","VIA C3")

hth,
Michael
 

Users who are viewing this thread

Back
Top Bottom