Sub-form totals

[Xfree]

I have looked an several posts on the subject of totals and grand totals on
sub-forms and forms with sub-forms and still can't get mine to work.

I have a sub-form called [Schedule] with the fields: part number,
numbermolds, and pourwt. everything works when I add a new record as far as
selecting a part number then it shows the proper pour weight. Then I enter a
number in the "numbermolds" field.

1st i need to total the line for that record =numbermolds*Pourwt to get
total pourwt per line item. Which I have done with no issues using: Pourwt
line item=[Numbermolds]*[Pourwt].

2nd I need to show a running total of the in the footer of the subreport
showing the total of Pourwt line item as I add records to the subreport. I
cant seem to get this to work. I have tried =Sum([Pourwt line item]) and have
also tried it with the Nz statement added.

Any help would be appreciated.

 

[Damon Heron]

"2nd I need to show a running total of the in the footer of the subreport
showing the total of Pourwt line item as I add records to the subreport."

Maybe re-read your sentence to see if it makes sense. You were talking about
subforms -or is it subreports?
Damon

 

[Xfree]

Should read:

"2nd I need to show a running total of the Pourwt line item in the footer of
the sub-form."

The grand total for Pourwt line item can be either in the footer of the
sub-form or on the main form. Looking at the big picture of what I am trying
to do it would be more usefully on the main form.


Hope this make sense

"2nd I need to show a running total of the Pourwt line item in the footer of the subreport showing the total of Pourwt line item as I add records to the subreport."

Maybe re-read your sentence to see if it makes sense. You were talking about
subforms -or is it sub-reports?
Damon

I have looked an several posts on the subject of totals and grand totals on
sub-forms and forms with sub-forms and still can't get mine to work.

I have a sub-form called [Schedule] with the fields: part number,
numbermolds, and pourwt. everything works when I add a new record as far
as
selecting a part number then it shows the proper pour weight. Then I enter
a
number in the "numbermolds" field.

1st i need to total the line for that record =numbermolds*Pourwt to get
total pourwt per line item. Which I have done with no issues using:
Pourwt line item=[Numbermolds]*[Pourwt].

2nd I need to show a running total of the in the footer of the subreport
showing the total of Pourwt line item as I add records to the subreport. I
cant seem to get this to work. I have tried =Sum([Pourwt line item]) and
have
also tried it with the Nz statement added.

Any help would be appreciated.

 

[Damon Heron]

Your subform is a datasheet, correct? In the form footer of the subform,
add a textbox, called UnitsonHand, and in the
control source of the textbox, type
=Sum(nz([your name of textbox you want to sum]))
Note that in a data sheet, the form footer is not visible.
Then, on the main form, add a textbox, and in the control source, type
=nz([Schedule].[Form]![UnitsOnHand],0)

Damon

Should read:

"2nd I need to show a running total of the Pourwt line item in the footer
of
the sub-form."

The grand total for Pourwt line item can be either in the footer of the
sub-form or on the main form. Looking at the big picture of what I am
trying
to do it would be more usefully on the main form.


Hope this make sense

"2nd I need to show a running total of the Pourwt line item in the footer
of the subreport showing the total of Pourwt line item as I add records
to the subreport."

Maybe re-read your sentence to see if it makes sense. You were talking
about
subforms -or is it sub-reports?
Damon

I have looked an several posts on the subject of totals and grand totals
on
sub-forms and forms with sub-forms and still can't get mine to work.

I have a sub-form called [Schedule] with the fields: part number,
numbermolds, and pourwt. everything works when I add a new record as
far
as
selecting a part number then it shows the proper pour weight. Then I
enter
a
number in the "numbermolds" field.

1st i need to total the line for that record =numbermolds*Pourwt to get
total pourwt per line item. Which I have done with no issues using:
Pourwt line item=[Numbermolds]*[Pourwt].

2nd I need to show a running total of the in the footer of the
subreport
showing the total of Pourwt line item as I add records to the
subreport. I
cant seem to get this to work. I have tried =Sum([Pourwt line item])
and
have
also tried it with the Nz statement added.

Any help would be appreciated.

 

[Xfree]

Damon,
Thanks for the help!

The first part is working, I am getting the correct numbers on the Sub form
footer textbox "UnitsonHand". I switched between datasheet and form to check
it. The second part however is not working, I get a "#error" in the main form
where I add a textbox, and then add in the control source,
=nz([Schedule].[Form]![UnitsOnHand],0) I must be missing something.

Your subform is a datasheet, correct? In the form footer of the subform,
add a textbox, called UnitsonHand, and in the
control source of the textbox, type
=Sum(nz([your name of textbox you want to sum]))
Note that in a data sheet, the form footer is not visible.
Then, on the main form, add a textbox, and in the control source, type
=nz([Schedule].[Form]![UnitsOnHand],0)

Damon

Should read:

"2nd I need to show a running total of the Pourwt line item in the footer
of
the sub-form."

The grand total for Pourwt line item can be either in the footer of the
sub-form or on the main form. Looking at the big picture of what I am
trying
to do it would be more usefully on the main form.


Hope this make sense

"2nd I need to show a running total of the Pourwt line item in the footer
of the subreport showing the total of Pourwt line item as I add records
to the subreport."

Maybe re-read your sentence to see if it makes sense. You were talking
about
subforms -or is it sub-reports?
Damon
I have looked an several posts on the subject of totals and grand totals
on
sub-forms and forms with sub-forms and still can't get mine to work.

I have a sub-form called [Schedule] with the fields: part number,
numbermolds, and pourwt. everything works when I add a new record as
far
as
selecting a part number then it shows the proper pour weight. Then I
enter
a
number in the "numbermolds" field.

1st i need to total the line for that record =numbermolds*Pourwt to get
total pourwt per line item. Which I have done with no issues using:
Pourwt line item=[Numbermolds]*[Pourwt].

2nd I need to show a running total of the in the footer of the
subreport
showing the total of Pourwt line item as I add records to the
subreport. I
cant seem to get this to work. I have tried =Sum([Pourwt line item])
and
have
also tried it with the Nz statement added.

Any help would be appreciated.

 

[Damon Heron]

Make sure the name "Schedule" is the real name of your subform.

Damon

Damon,
Thanks for the help!

The first part is working, I am getting the correct numbers on the Sub
form
footer textbox "UnitsonHand". I switched between datasheet and form to
check
it. The second part however is not working, I get a "#error" in the main
form
where I add a textbox, and then add in the control source,
=nz([Schedule].[Form]![UnitsOnHand],0) I must be missing something.

Your subform is a datasheet, correct? In the form footer of the subform,
add a textbox, called UnitsonHand, and in the
control source of the textbox, type
=Sum(nz([your name of textbox you want to sum]))
Note that in a data sheet, the form footer is not visible.
Then, on the main form, add a textbox, and in the control source, type
=nz([Schedule].[Form]![UnitsOnHand],0)

Damon

Should read:

"2nd I need to show a running total of the Pourwt line item in the
footer
of
the sub-form."

The grand total for Pourwt line item can be either in the footer of the
sub-form or on the main form. Looking at the big picture of what I am
trying
to do it would be more usefully on the main form.


Hope this make sense



:

"2nd I need to show a running total of the Pourwt line item in the
footer
of the subreport showing the total of Pourwt line item as I add
records
to the subreport."

Maybe re-read your sentence to see if it makes sense. You were talking
about
subforms -or is it sub-reports?
Damon
I have looked an several posts on the subject of totals and grand
totals
on
sub-forms and forms with sub-forms and still can't get mine to work.

I have a sub-form called [Schedule] with the fields: part number,
numbermolds, and pourwt. everything works when I add a new record as
far
as
selecting a part number then it shows the proper pour weight. Then I
enter
a
number in the "numbermolds" field.

1st i need to total the line for that record =numbermolds*Pourwt to
get
total pourwt per line item. Which I have done with no issues using:
Pourwt line item=[Numbermolds]*[Pourwt].

2nd I need to show a running total of the in the footer of the
subreport
showing the total of Pourwt line item as I add records to the
subreport. I
cant seem to get this to work. I have tried =Sum([Pourwt line item])
and
have
also tried it with the Nz statement added.

Any help would be appreciated.

 

[Xfree]

Its working now thank you Damon.

Make sure the name "Schedule" is the real name of your subform.

Damon

Damon,
Thanks for the help!

The first part is working, I am getting the correct numbers on the Sub
form
footer textbox "UnitsonHand". I switched between datasheet and form to
check
it. The second part however is not working, I get a "#error" in the main
form
where I add a textbox, and then add in the control source,
=nz([Schedule].[Form]![UnitsOnHand],0) I must be missing something.

Your subform is a datasheet, correct? In the form footer of the subform,
add a textbox, called UnitsonHand, and in the
control source of the textbox, type
=Sum(nz([your name of textbox you want to sum]))
Note that in a data sheet, the form footer is not visible.
Then, on the main form, add a textbox, and in the control source, type
=nz([Schedule].[Form]![UnitsOnHand],0)

Damon



Should read:

"2nd I need to show a running total of the Pourwt line item in the
footer
of
the sub-form."

The grand total for Pourwt line item can be either in the footer of the
sub-form or on the main form. Looking at the big picture of what I am
trying
to do it would be more usefully on the main form.


Hope this make sense



:

"2nd I need to show a running total of the Pourwt line item in the
footer
of the subreport showing the total of Pourwt line item as I add
records
to the subreport."

Maybe re-read your sentence to see if it makes sense. You were talking
about
subforms -or is it sub-reports?
Damon
I have looked an several posts on the subject of totals and grand
totals
on
sub-forms and forms with sub-forms and still can't get mine to work.

I have a sub-form called [Schedule] with the fields: part number,
numbermolds, and pourwt. everything works when I add a new record as
far
as
selecting a part number then it shows the proper pour weight. Then I
enter
a
number in the "numbermolds" field.

1st i need to total the line for that record =numbermolds*Pourwt to
get
total pourwt per line item. Which I have done with no issues using:
Pourwt line item=[Numbermolds]*[Pourwt].

2nd I need to show a running total of the in the footer of the
subreport
showing the total of Pourwt line item as I add records to the
subreport. I
cant seem to get this to work. I have tried =Sum([Pourwt line item])
and
have
also tried it with the Nz statement added.

Any help would be appreciated.