Expressions for a subtotal in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HELP. I have no hair left. I am trying to add a field to a form which
subtotals an amount on a subform. I can't seem to get the expression right.
Can anyone out there please help me? I've tried everything but the right
thing.
Thanks.
Barb
 
How would I format that in? I tried that but it comes up with "?Name" in the
field and not the total.
 
I must have typed in 100 different things, but the one I think that was
supose to work was DSum"Mod"(["modtotal"]+["modtotal"]=total
Mod being the sub table and mod total being the field that is supose to add
up and display in a field on the main form.
 
Try placing by placing in the form footer =Sum(the expression used to
obtain ModTotal)
I must have typed in 100 different things, but the one I think that was
supose to work was DSum"Mod"(["modtotal"]+["modtotal"]=total
Mod being the sub table and mod total being the field that is supose to add
up and display in a field on the main form.
Please post exactly what you typed in the field...
Click to expand...
[quoted text clipped - 14 lines]
Click to expand...
 
Well, that's the thing. I am not sure what the expression is or how to format
it. I have the text box in the footer I just can't seem to get it to total
and then to show up in a test box on the main form.

Chris B via AccessMonster.com said:
Try placing by placing in the form footer =Sum(the expression used to
obtain ModTotal)
I must have typed in 100 different things, but the one I think that was
supose to work was DSum"Mod"(["modtotal"]+["modtotal"]=total
Mod being the sub table and mod total being the field that is supose to add
up and display in a field on the main form.
Please post exactly what you typed in the field...
Click to expand...
[quoted text clipped - 14 lines]
Thanks.
Barb
Click to expand...
Click to expand...
Click to expand...
 
=sum([ModTotal])
Well, that's the thing. I am not sure what the expression is or how to format
it. I have the text box in the footer I just can't seem to get it to total
and then to show up in a test box on the main form.
Try placing by placing in the form footer =Sum(the expression used to
obtain ModTotal)
Click to expand...
[quoted text clipped - 9 lines]
Click to expand...
 
Back
Top