DS said:
Duane said:
=Nz(DSum("[Expr1]","SalesDetailsQ","[SalesID]=" &
Forms!SalesDetails!SalesID & " AND [SDTaxed]=True"), [value if the
expression is null])
This assume SalesID is numeric.
Thanks Duane, The SalesID is Numeric..... I cut and pasted the entire
phrase from =Nz(...................to is null])
but I'm getting a %Name# in the box. Any idea why?
Thanks
DS
Duane,,,,Inspiration came quickly. This worked.
=Nz(DSum("[Expr1]","SalesDetailsQ","[SalesID]=" & Forms!Sales!SalesID & "
AND [SDTaxed]=True"))
Thanks Duane, your help is greatly appreciated.
DS