DSum Wrong Argument

[DS]

I'm trying to use this DSum function but I keep getting the wrong number
of arguments. Any help appreciated.
Thanks
DS


Me.TxtTax = DSum(IIf(CDDiscountDP = 1, "((CDQuantity *
CDFinalPrice)+CDiscountAmount)*CDTaxRate",
((CDQuantity * CDFinalPrice) * CDDiscountPercent) * CDTaxRate,
"tblCheckDetails"))

 

[Cindy]

Try this instead:
DSum(IIf(CDDiscountDP = 1, "((CDQuantity * CDFinalPrice)
+CDiscountAmount)*CDTaxRate",
"((CDQuantity * CDFinalPrice) * CDDiscountPercent) * CDTaxRate"
),"tblCheckDetails")

Cindy

 

[DS]

Try this instead:
DSum(IIf(CDDiscountDP = 1, "((CDQuantity * CDFinalPrice)
+CDiscountAmount)*CDTaxRate",
"((CDQuantity * CDFinalPrice) * CDDiscountPercent) * CDTaxRate"
),"tblCheckDetails")
Cindy

Thanks Cindy
That did the trick!
DS