Question about calculations in Access

[Guest]

Good Afternoon,
I hope that I can explain this clearly... I have a Table and a Form called
purchase orders, and inside it has a subform. On this subform it shows
Invoice number, transaction date, product name, units ordered, units
received, units backordered, discontinued, unit price, subtotal. In the
subtotal column I have it totaling the units received and unit price to get a
sutotal for each item, and it shows it for each item that was shipped by that
invoice number. I would like to then have a grand total that adds up all the
subtotals in that invoice number. How do I get a grand total for the
subtotal column? I appreciate any help you can offer. Thank you in advance!
: )
Cathleen

 

[Ron Hinds]

Add a field GrandTotal and set it's ControlSource to =Sum([SubTotal]).

 

[Guest]

Thank you so much for replying back but I having problems. I created the
field but the boxes are empty. I also what one box that shows the one total
not a box for each item. Can you offer any other suggestions? Thank you so
much for your help, it is really appreciated.
Cathleen

Add a field GrandTotal and set it's ControlSource to =Sum([SubTotal]).

Good Afternoon,
I hope that I can explain this clearly... I have a Table and a Form called
purchase orders, and inside it has a subform. On this subform it shows
Invoice number, transaction date, product name, units ordered, units
received, units backordered, discontinued, unit price, subtotal. In the
subtotal column I have it totaling the units received and unit price to get a
sutotal for each item, and it shows it for each item that was shipped by that
invoice number. I would like to then have a grand total that adds up all the
subtotals in that invoice number. How do I get a grand total for the
subtotal column? I appreciate any help you can offer. Thank you in advance!
: )
Cathleen

 

[Ron Hinds]

Put the box for Grand Total in he Form Footer - that way it will only be
there once for everything. Also, make sure the filed name in brackets is
correct - I just used SubTotal as an example - it needs to be the same name
as your subtotal field.

Thank you so much for replying back but I having problems. I created the
field but the boxes are empty. I also what one box that shows the one total
not a box for each item. Can you offer any other suggestions? Thank you so
much for your help, it is really appreciated.
Cathleen

Add a field GrandTotal and set it's ControlSource to =Sum([SubTotal]).

Good Afternoon,
I hope that I can explain this clearly... I have a Table and a Form called
purchase orders, and inside it has a subform. On this subform it shows
Invoice number, transaction date, product name, units ordered, units
received, units backordered, discontinued, unit price, subtotal. In the
subtotal column I have it totaling the units received and unit price

to
get a

sutotal for each item, and it shows it for each item that was shipped

by
that

invoice number. I would like to then have a grand total that adds up

all
the

subtotals in that invoice number. How do I get a grand total for the
subtotal column? I appreciate any help you can offer. Thank you in advance!
: )
Cathleen

 

[Guest]

Im sorry Ron but I must be an idiot. I moved the box into the form footer
and checked the name and the brackets, and it sort of works. It just shows
the top subtotal not the sum of all the subtotals what am I doing wrong?
This is what I have
=Sum[Purchase Orders Subform].Form!Subtotal. Thanks again for your help and
patience.
Thanks Again,
Cathleen

Put the box for Grand Total in he Form Footer - that way it will only be
there once for everything. Also, make sure the filed name in brackets is
correct - I just used SubTotal as an example - it needs to be the same name
as your subtotal field.

Thank you so much for replying back but I having problems. I created the
field but the boxes are empty. I also what one box that shows the one total
not a box for each item. Can you offer any other suggestions? Thank you so
much for your help, it is really appreciated.
Cathleen

Add a field GrandTotal and set it's ControlSource to =Sum([SubTotal]).

Good Afternoon,
I hope that I can explain this clearly... I have a Table and a Form
called
purchase orders, and inside it has a subform. On this subform it shows
Invoice number, transaction date, product name, units ordered, units
received, units backordered, discontinued, unit price, subtotal. In the
subtotal column I have it totaling the units received and unit price to
get a
sutotal for each item, and it shows it for each item that was shipped by
that
invoice number. I would like to then have a grand total that adds up all
the
subtotals in that invoice number. How do I get a grand total for the
subtotal column? I appreciate any help you can offer. Thank you in
advance!
: )
Cathleen

 

[Ron Hinds]

Try it like this (parentheses added):

=Sum([Purchase Orders Subform].Form!Subtotal)

Im sorry Ron but I must be an idiot. I moved the box into the form footer
and checked the name and the brackets, and it sort of works. It just shows
the top subtotal not the sum of all the subtotals what am I doing wrong?
This is what I have
=Sum[Purchase Orders Subform].Form!Subtotal. Thanks again for your help and
patience.
Thanks Again,
Cathleen

Put the box for Grand Total in he Form Footer - that way it will only be
there once for everything. Also, make sure the filed name in brackets is
correct - I just used SubTotal as an example - it needs to be the same name
as your subtotal field.

Thank you so much for replying back but I having problems. I created the
field but the boxes are empty. I also what one box that shows the one total
not a box for each item. Can you offer any other suggestions? Thank

you
so

much for your help, it is really appreciated.
Cathleen

:

Add a field GrandTotal and set it's ControlSource to =Sum([SubTotal]).

Good Afternoon,
I hope that I can explain this clearly... I have a Table and a Form
called
purchase orders, and inside it has a subform. On this subform it shows
Invoice number, transaction date, product name, units ordered, units
received, units backordered, discontinued, unit price, subtotal.

In
the

subtotal column I have it totaling the units received and unit

price
to

get a
sutotal for each item, and it shows it for each item that was

shipped
by

that
invoice number. I would like to then have a grand total that adds

up
all

the
subtotals in that invoice number. How do I get a grand total for the
subtotal column? I appreciate any help you can offer. Thank you in
advance!
: )
Cathleen

 

[Guest]

Now it shows #error. Is there anything else I can do? Thanks again for your
patience: )

Try it like this (parentheses added):

=Sum([Purchase Orders Subform].Form!Subtotal)

Im sorry Ron but I must be an idiot. I moved the box into the form footer
and checked the name and the brackets, and it sort of works. It just shows
the top subtotal not the sum of all the subtotals what am I doing wrong?
This is what I have
=Sum[Purchase Orders Subform].Form!Subtotal. Thanks again for your help and
patience.
Thanks Again,
Cathleen

Put the box for Grand Total in he Form Footer - that way it will only be
there once for everything. Also, make sure the filed name in brackets is
correct - I just used SubTotal as an example - it needs to be the same name
as your subtotal field.

Thank you so much for replying back but I having problems. I created the
field but the boxes are empty. I also what one box that shows the one
total
not a box for each item. Can you offer any other suggestions? Thank you
so
much for your help, it is really appreciated.
Cathleen

:

Add a field GrandTotal and set it's ControlSource to =Sum([SubTotal]).

Good Afternoon,
I hope that I can explain this clearly... I have a Table and a Form
called
purchase orders, and inside it has a subform. On this subform it
shows
Invoice number, transaction date, product name, units ordered, units
received, units backordered, discontinued, unit price, subtotal. In
the
subtotal column I have it totaling the units received and unit price
to
get a
sutotal for each item, and it shows it for each item that was shipped
by
that
invoice number. I would like to then have a grand total that adds up
all
the
subtotals in that invoice number. How do I get a grand total for the
subtotal column? I appreciate any help you can offer. Thank you in
advance!
: )
Cathleen

 

[Ron Hinds]

OK - let's take this one step at a time.

1.) Is the Footer on the subform? It doesn't seem to be from the syntax you
are using. That can get a little tricky... we won't go there unless the
answer is "yes" ;-)

2.) Is the Subtotal's Control Source a field named Subtotal or is it a
calculated value? If it is a calculated value, then try setting the Grand
Total's Control Source to be a sum of the calculation, e.g.:

=Sum([untis received]*[unit price])

Now it shows #error. Is there anything else I can do? Thanks again for your
patience: )

Try it like this (parentheses added):

=Sum([Purchase Orders Subform].Form!Subtotal)

Im sorry Ron but I must be an idiot. I moved the box into the form footer
and checked the name and the brackets, and it sort of works. It just shows
the top subtotal not the sum of all the subtotals what am I doing wrong?
This is what I have
=Sum[Purchase Orders Subform].Form!Subtotal. Thanks again for your

help
and

patience.
Thanks Again,
Cathleen

:

Put the box for Grand Total in he Form Footer - that way it will only be
there once for everything. Also, make sure the filed name in brackets is
correct - I just used SubTotal as an example - it needs to be the

same
name

as your subtotal field.

Thank you so much for replying back but I having problems. I

created
the

field but the boxes are empty. I also what one box that shows the one
total
not a box for each item. Can you offer any other suggestions?

Thank
you

so
much for your help, it is really appreciated.
Cathleen

:

Add a field GrandTotal and set it's ControlSource to =Sum([SubTotal]).

Good Afternoon,
I hope that I can explain this clearly... I have a Table and

a
Form

called
purchase orders, and inside it has a subform. On this subform it
shows
Invoice number, transaction date, product name, units ordered, units
received, units backordered, discontinued, unit price,

subtotal.
In

the
subtotal column I have it totaling the units received and unit price
to
get a
sutotal for each item, and it shows it for each item that was shipped
by
that
invoice number. I would like to then have a grand total that

adds
up

all
the
subtotals in that invoice number. How do I get a grand total

for
the

subtotal column? I appreciate any help you can offer. Thank

you
in

advance!
: )
Cathleen

 

[Guest]

Great, thank you for helping so much because I am at a loss on what to do.
1.) no its on the main form
2.) The control source on the Subtotal field is a calculated field and looks
like this:
=[UnitPrice]*[Units Ordered] and I just put the calculation into the grand
total field as =Sum([UnitPrice]*[Units Ordered]) and it it still showing
#ERROR. I just cant believe that this silly thing still wont work. Im sorry
but di you have any more suggestions.

OK - let's take this one step at a time.

1.) Is the Footer on the subform? It doesn't seem to be from the syntax you
are using. That can get a little tricky... we won't go there unless the
answer is "yes" ;-)

2.) Is the Subtotal's Control Source a field named Subtotal or is it a
calculated value? If it is a calculated value, then try setting the Grand
Total's Control Source to be a sum of the calculation, e.g.:

=Sum([untis received]*[unit price])

Now it shows #error. Is there anything else I can do? Thanks again for your
patience: )

Try it like this (parentheses added):

=Sum([Purchase Orders Subform].Form!Subtotal)

Im sorry Ron but I must be an idiot. I moved the box into the form footer
and checked the name and the brackets, and it sort of works. It just
shows
the top subtotal not the sum of all the subtotals what am I doing wrong?
This is what I have
=Sum[Purchase Orders Subform].Form!Subtotal. Thanks again for your help
and
patience.
Thanks Again,
Cathleen

:

Put the box for Grand Total in he Form Footer - that way it will only be
there once for everything. Also, make sure the filed name in brackets is
correct - I just used SubTotal as an example - it needs to be the same
name
as your subtotal field.

Thank you so much for replying back but I having problems. I created
the
field but the boxes are empty. I also what one box that shows the one
total
not a box for each item. Can you offer any other suggestions? Thank
you
so
much for your help, it is really appreciated.
Cathleen

:

Add a field GrandTotal and set it's ControlSource to
=Sum([SubTotal]).

Good Afternoon,
I hope that I can explain this clearly... I have a Table and a
Form
called
purchase orders, and inside it has a subform. On this subform it
shows
Invoice number, transaction date, product name, units ordered,
units
received, units backordered, discontinued, unit price, subtotal.
In
the
subtotal column I have it totaling the units received and unit
price
to
get a
sutotal for each item, and it shows it for each item that was
shipped
by
that
invoice number. I would like to then have a grand total that adds
up
all
the
subtotals in that invoice number. How do I get a grand total for
the
subtotal column? I appreciate any help you can offer. Thank you
in
advance!
: )
Cathleen

 

[Guest]

I just tried to link the grand total field to the subform and this is what I
put in as a calculation:
=Sum([Purchase Orders Subform].[Form]![UnitPrice]*[[Purchase Orders
Subform].[Form]![Units Ordered])
It still shows #ERROR. Dont know why its being so stuborn. I hope you have
more up your magic sleeve. Thank you again!

Great, thank you for helping so much because I am at a loss on what to do.
1.) no its on the main form
2.) The control source on the Subtotal field is a calculated field and looks
like this:
=[UnitPrice]*[Units Ordered] and I just put the calculation into the grand
total field as =Sum([UnitPrice]*[Units Ordered]) and it it still showing
#ERROR. I just cant believe that this silly thing still wont work. Im sorry
but di you have any more suggestions.

OK - let's take this one step at a time.

1.) Is the Footer on the subform? It doesn't seem to be from the syntax you
are using. That can get a little tricky... we won't go there unless the
answer is "yes" ;-)

2.) Is the Subtotal's Control Source a field named Subtotal or is it a
calculated value? If it is a calculated value, then try setting the Grand
Total's Control Source to be a sum of the calculation, e.g.:

=Sum([untis received]*[unit price])

Now it shows #error. Is there anything else I can do? Thanks again for your
patience: )

:

Try it like this (parentheses added):

=Sum([Purchase Orders Subform].Form!Subtotal)

Im sorry Ron but I must be an idiot. I moved the box into the form footer
and checked the name and the brackets, and it sort of works. It just
shows
the top subtotal not the sum of all the subtotals what am I doing wrong?
This is what I have
=Sum[Purchase Orders Subform].Form!Subtotal. Thanks again for your help
and
patience.
Thanks Again,
Cathleen

:

Put the box for Grand Total in he Form Footer - that way it will only be
there once for everything. Also, make sure the filed name in brackets is
correct - I just used SubTotal as an example - it needs to be the same
name
as your subtotal field.

Thank you so much for replying back but I having problems. I created
the
field but the boxes are empty. I also what one box that shows the one
total
not a box for each item. Can you offer any other suggestions? Thank
you
so
much for your help, it is really appreciated.
Cathleen

:

Add a field GrandTotal and set it's ControlSource to
=Sum([SubTotal]).

Good Afternoon,
I hope that I can explain this clearly... I have a Table and a
Form
called
purchase orders, and inside it has a subform. On this subform it
shows
Invoice number, transaction date, product name, units ordered,
units
received, units backordered, discontinued, unit price, subtotal.
In
the
subtotal column I have it totaling the units received and unit
price
to
get a
sutotal for each item, and it shows it for each item that was
shipped
by
that
invoice number. I would like to then have a grand total that adds
up
all
the
subtotals in that invoice number. How do I get a grand total for
the
subtotal column? I appreciate any help you can offer. Thank you
in
advance!
: )
Cathleen