Bad IIf

  • Thread starter Thread starter DS
  • Start date Start date
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]))
 
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]
 
Back
Top