trying for a subtotal

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jandk - 02 Apr 2008 17:48 GMT

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.

Reply to this Message

Jeff Boyce - 02 Apr 2008 18:52 GMT

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

>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.
[quoted text clipped - 8 lines]
> =sumOrderDetails.Form!Total
> and they both show #error.

Reply to this Message