trying for a subtotal

J

jandk

I am trying to create a subtotal field in my footer re: a calculated field.
I have used the Northwind route and I only get a line-item display.

=[Sales details Subform1].Form!Total is what I have that makes the line-item
display, as does =[Orders Subform].[Form]![OrderSubtotal], only with my
particular name formats.

I have tried these:
=Sum([Sales details Subform1].Form!total)
=sumOrderDetails.Form!Total
and they both show #error.
 
J

Jeff Boyce

I'm not sure from your description, but it sounds like you want a footer (of
a main form) to display the sum of detail records shown in a subform. If
so, take a look at HELP for Expressions. You need to provide the full path,
something like (untested):

Sum(Forms!YourMainForm.YourSubformControlName.Form!YourControlNameInSubform)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create custom labels from an csv file + Need items numerically counted out 0
Forms/Subforms Calculation issues 1
Synchronizing subforms 0
Getting a subform control to requery 3
Form Problem 1
Trouble with subtotal in form footer 4
Filtering and summing a calculated field on a subform 0
Mainform Text Box that should copy subTotal in a subform 5

Top