Hi there,
I'm new here but have a rather annoying problem with the IIf command.

Can anyone spot what is wrong with this IIf command : =IIf([DrvMSAHistoric]="True","A","")

DrvMSAHistoric is in the Field List, yet when I run the report, it returns back the black space rather than the A. :(

Thank you in advance,

Andy

"true" is a string

try

=IIf([DrvMSAHistoric]=True,"A","")

Actually if DrvMASHistoric is a true/false field you dont need to use =...

=IIf([DrvMSAHistoric],"A","")

Will do...

Namliam,
You are a total superstar!! I've been pulling my hair out for days over this and you solved it for me in seconds! Thank you so so much!!!!!!
:D:D:D

Ray had it first though! I just added a little nugget of wisdom to it...
Kudo's go to Ray :)

appreciate it

Yeah a big big thanks to you too Ray :D