Bad IIf

[DS]

This if statement in a Query always returns the first value.....any
help is appreciated.
Thanks
DS
N2: IIf([tblCheckDetails].[CDDiscountDP]>=1 And
[tblCheckDetails].[CDDiscountAction]<>"B"," " & "*" &
[tblDiscounts].[DiscountName],IIf([tblCheckDetails].[CDDiscountDP]>=1
And [CDDiscountAction]="A"," " & "**" & [tblDiscounts].[DiscountName]))

 

[John W. Vinson]

This if statement in a Query always returns the first value.....any
help is appreciated.
Thanks
DS
N2: IIf([tblCheckDetails].[CDDiscountDP]>=1 And
[tblCheckDetails].[CDDiscountAction]<>"B"," " & "*" &
[tblDiscounts].[DiscountName],IIf([tblCheckDetails].[CDDiscountDP]>=1
And [CDDiscountAction]="A"," " & "**" & [tblDiscounts].[DiscountName]))

Could you please describe in words what the query is intended to do? What is
the context - is this a calculated field in the query?


John W. Vinson [MVP]