Dsum newbie

[Benj]

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!

[accesstos]

The error message had to be "Invalid use of Me keyword".

Remove the [Me]. from the [Me].[Parent]![PrimKey] and will work as you expect.

Also, change the IIf(IsNull([Reason]=True), to IIf(IsNull([Reason])=True, or to the simplest IIf(IsNull([Reason]),

[Benj]

Hi accesstos! I already removed the [Me] but it now shows Error. My old file doesnt have a [Me] on it and it worked. But before my primary key is not autonumber, i have to enter a text (as a primary key). I was told that its not a good idea to do that so I added a new primary key which was PrimKey for parent and Primkeys for the child. Not sure where i screwed up. Thanks so much!

[accesstos]

Hi Benj!
It seems that you are doing more steps than you need.
If subform (child) is bound to qrypiglet put your unbound text box in form footer of subform with the expression: =SUM([ptot])

You welcome!

[Benj]

hi benj!
It seems that you are doing more steps than you need.
If subform (child) is bound to qrypiglet put your unbound text box in form footer of subform with the expression: =sum([ptot])

you welcome!

thank you so much! Its working now