B
Bongard
Hi, I have a query where I am using an iif statement so that my field
we either equal text or number depending on the value of another
field. Here is my iif statement
Portfolio1:
IIf([qry_mhfsac4dPassThrough.SecId]="60934n583","FPA",IIf([qry_mhfsac4dPassThrough.SecId]="825252646","Aim",CInt([portfolio])))
I am basically saying that if the SecID of a security is x then"FPA"
or "AIM" otherwise I want to see the portfolio number. However,
whether I use the formula cint() or val() or a couple others that I
have tried, this field still comes out to be text when the last part
of the iif statement is true.
Anyone have any ideas?
Much appreciated,
Brian
we either equal text or number depending on the value of another
field. Here is my iif statement
Portfolio1:
IIf([qry_mhfsac4dPassThrough.SecId]="60934n583","FPA",IIf([qry_mhfsac4dPassThrough.SecId]="825252646","Aim",CInt([portfolio])))
I am basically saying that if the SecID of a security is x then"FPA"
or "AIM" otherwise I want to see the portfolio number. However,
whether I use the formula cint() or val() or a couple others that I
have tried, this field still comes out to be text when the last part
of the iif statement is true.
Anyone have any ideas?
Much appreciated,
Brian