Bad IIf

D

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]))
 
J

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]))
Click to expand...

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]
 
Top