summing totals from subform on mainform

E

Erin Freeman

Hi there,

I have looked through the posts to see if i could find some help on it but i
still cant get things to work...

I have a form called Billing Panel.

I have a subform called BillingPanelTravelSubform

The Billing Panel shows all the information for a work order

The subform is linked by work order number

There are for example 5 Travel invoices for one work order which means there
are 5 records in the subform.

I have a field on the subform called "T Total Travel" (which is an
expression) and in the footer of the subform i have an unbound text box with
the expression =sum([T Total Travel]) - This generates the #ERROR

I just would like to show a total for that one work order all of the T Total
Travel Amounts......

Thanks in advance
 
E

Erin Freeman

so i have taken care of the #Error issue on the subform, however it is not
summing all the records, just what is on that record...
 
J

Jeanette Cunningham

Hi Erin,
Each record on your subform has a text box for TotalTravel.
Remove the txtbox called T Total Travel.
To find the sum of TotalTravel for all records on the subform use an unbound
textbox in the header or footer, set its datasource to =Sum([TotalTravel]).


Jeanette Cunningham


Erin Freeman said:
so i have taken care of the #Error issue on the subform, however it is
not
summing all the records, just what is on that record...

Erin Freeman said:
Hi there,

I have looked through the posts to see if i could find some help on it
but i
still cant get things to work...

I have a form called Billing Panel.

I have a subform called BillingPanelTravelSubform

The Billing Panel shows all the information for a work order

The subform is linked by work order number

There are for example 5 Travel invoices for one work order which means
there
are 5 records in the subform.

I have a field on the subform called "T Total Travel" (which is an
expression) and in the footer of the subform i have an unbound text box
with
the expression =sum([T Total Travel]) - This generates the #ERROR

I just would like to show a total for that one work order all of the T
Total
Travel Amounts......

Thanks in advance
 
E

Erin Freeman

Hi Jeanette,

I think I explained that wrong...

Mainform - Work Order

Subform - Travel
Record 1 - Travel To amount = 5.00
Record 2 - Travel To amount = 5.00
Record 3 - Travel To amount = 5.00
Record 4 - Travel To amount = 10.00
Record 5 - Travel To amount = 10.00

I have 5 "Travel" records that belong to my main work order form.
I want to show the total for that one work order for all 5 of the travel
records so
the total i would want to show in the example above in a text box on the
main form would be 35.00.

Thanks in advance
Jeanette Cunningham said:
Hi Erin,
Each record on your subform has a text box for TotalTravel.
Remove the txtbox called T Total Travel.
To find the sum of TotalTravel for all records on the subform use an unbound
textbox in the header or footer, set its datasource to =Sum([TotalTravel]).


Jeanette Cunningham


Erin Freeman said:
so i have taken care of the #Error issue on the subform, however it is
not
summing all the records, just what is on that record...

Erin Freeman said:
Hi there,

I have looked through the posts to see if i could find some help on it
but i
still cant get things to work...

I have a form called Billing Panel.

I have a subform called BillingPanelTravelSubform

The Billing Panel shows all the information for a work order

The subform is linked by work order number

There are for example 5 Travel invoices for one work order which means
there
are 5 records in the subform.

I have a field on the subform called "T Total Travel" (which is an
expression) and in the footer of the subform i have an unbound text box
with
the expression =sum([T Total Travel]) - This generates the #ERROR

I just would like to show a total for that one work order all of the T
Total
Travel Amounts......

Thanks in advance
 

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

Top