I couldnt figure why the result shows #Name for the field. Its an unbound field =DSum("ptot","qrypiglet","PrimKeys = '" & [Me].[Parent]![PrimKey] & "'")
where ptot: IIf(IsNull([Reason]=True),[PigNum],[PigNum]*-1)
PrimKeys is the child linked to the PrimKey (parent)
thanks!