M MikeC Sep 21, 2004 #1 The built-in Dsum function should work: =DSum("Nz([QuantitySum], 0)","YourTable","[Bonus] = " & False)
The built-in Dsum function should work: =DSum("Nz([QuantitySum], 0)","YourTable","[Bonus] = " & False)
M Marshall Barton Sep 21, 2004 #2 MikeC said: The built-in Dsum function should work: =DSum("Nz([QuantitySum], 0)","YourTable","[Bonus] = " & False) -----Original Message----- In a report I need to add the quantity to a =SUM( only if the Bonus (a logical -True or False field) is False. Something like this - If ([Bonus] = False, =Sum([QuantitySum]). Does any one know the Click to expand... correct syntax?? Click to expand... I can't see the original post so I'll jump in here. This can be done with Sum : =Sum(IIf(Bonus, 0, Quantity))
MikeC said: The built-in Dsum function should work: =DSum("Nz([QuantitySum], 0)","YourTable","[Bonus] = " & False) -----Original Message----- In a report I need to add the quantity to a =SUM( only if the Bonus (a logical -True or False field) is False. Something like this - If ([Bonus] = False, =Sum([QuantitySum]). Does any one know the Click to expand... correct syntax?? Click to expand... I can't see the original post so I'll jump in here. This can be done with Sum : =Sum(IIf(Bonus, 0, Quantity))
