Total or pre calculated column

Hi,

My report provides a list of supplied products, these can range from on item
to many. I have a control which calculates the amount of product ordered
plus a wastage =[Qty]+[Wastage] to give a total quantity for that particular
line.

I want to have a total of all the lines. In the Order footer I have placed
the control =Sum([ProdTotal]) ProdTotal being the name of the above control,
however when I view the report it ask for a perameter value.

Am I missing something or will the report not calculate from a previously
calculated control?

Many thanks in advance

Charlotte

You can't Sum() controls. You can Sum() expressions derived from the record
source of your report. Assuming Qty and Wastage are fields, try:
=Sum([Qty]+[Wastage])

--
Duane Hookom
MS Access MVP


"Charlie" wrote in message
...
Hi,

My report provides a list of supplied products, these can range from on
item
to many. I have a control which calculates the amount of product ordered
plus a wastage =[Qty]+[Wastage] to give a total quantity for that
particular
line.

I want to have a total of all the lines. In the Order footer I have
placed
the control =Sum([ProdTotal]) ProdTotal being the name of the above
control,
however when I view the report it ask for a perameter value.

Am I missing something or will the report not calculate from a previously
calculated control?

Many thanks in advance

Charlotte

Hi Duane,

Both the Qty and Wastage are controls, which explains why it is not working.
Is there a way to get the fields to make the calculations without using a
query or control?

Charlotte

"Duane Hookom" wrote:

You can't Sum() controls. You can Sum() expressions derived from the record
source of your report. Assuming Qty and Wastage are fields, try:
=Sum([Qty]+[Wastage])

--
Duane Hookom
MS Access MVP


"Charlie" wrote in message
...
Hi,

My report provides a list of supplied products, these can range from on
item
to many. I have a control which calculates the amount of product ordered
plus a wastage =[Qty]+[Wastage] to give a total quantity for that
particular
line.

I want to have a total of all the lines. In the Order footer I have
placed
the control =Sum([ProdTotal]) ProdTotal being the name of the above
control,
however when I view the report it ask for a perameter value.

Am I missing something or will the report not calculate from a previously
calculated control?

Many thanks in advance

Charlotte

You haven't told us anything about the control source properties of the
controls. You can typically Sum() the control source like:
=Sum([Qty] * [UnitPrice] * (1-[Discount))

--
Duane Hookom
Microsoft Access MVP


"Charlie" wrote:

Hi Duane,

Both the Qty and Wastage are controls, which explains why it is not working.
Is there a way to get the fields to make the calculations without using a
query or control?

Charlotte

"Duane Hookom" wrote:

You can't Sum() controls. You can Sum() expressions derived from the record
source of your report. Assuming Qty and Wastage are fields, try:
=Sum([Qty]+[Wastage])

--
Duane Hookom
MS Access MVP


"Charlie" wrote in message
...
Hi,

My report provides a list of supplied products, these can range from on
item
to many. I have a control which calculates the amount of product ordered
plus a wastage =[Qty]+[Wastage] to give a total quantity for that
particular
line.

I want to have a total of all the lines. In the Order footer I have
placed
the control =Sum([ProdTotal]) ProdTotal being the name of the above
control,
however when I view the report it ask for a perameter value.

Am I missing something or will the report not calculate from a previously
calculated control?

Many thanks in advance

Charlotte

Hi Duane,

The control which I want to get a total from is:
=(([PageCount]*[Qty])/[NumberOnSheet]*0.03)+([PageCount]*[Qty])/[NumberOnSheet]+0.5

PageCount, Qty and NumberOnSheet are all fed from a form however I need the
0.03 to be added on for wastage with the addition of .5 so it always rounds
to the highest value.

If possible I am happy to get the form to make this calculation but I am
unaware on how to get this to store in a table without the use of a query.

Thanks

Charlotte

"Duane Hookom" wrote:

You haven't told us anything about the control source properties of the
controls. You can typically Sum() the control source like:
=Sum([Qty] * [UnitPrice] * (1-[Discount))

--
Duane Hookom
Microsoft Access MVP


"Charlie" wrote:

Hi Duane,

Both the Qty and Wastage are controls, which explains why it is not working.
Is there a way to get the fields to make the calculations without using a
query or control?

Charlotte

Did you try sum the expression like:
=Sum((([PageCount]*[Qty])/[NumberOnSheet]*0.03)+([PageCount]*[Qty])/[NumberOnSheet]+0.5)

--
Duane Hookom
Microsoft Access MVP


"Charlie" wrote:

Hi Duane,

The control which I want to get a total from is:
=(([PageCount]*[Qty])/[NumberOnSheet]*0.03)+([PageCount]*[Qty])/[NumberOnSheet]+0.5

PageCount, Qty and NumberOnSheet are all fed from a form however I need the
0.03 to be added on for wastage with the addition of .5 so it always rounds
to the highest value.

If possible I am happy to get the form to make this calculation but I am
unaware on how to get this to store in a table without the use of a query.

Thanks

Charlotte

"Duane Hookom" wrote:

You haven't told us anything about the control source properties of the
controls. You can typically Sum() the control source like:
=Sum([Qty] * [UnitPrice] * (1-[Discount))

--
Duane Hookom
Microsoft Access MVP


"Charlie" wrote:

Hi Duane,

Both the Qty and Wastage are controls, which explains why it is not working.
Is there a way to get the fields to make the calculations without using a
query or control?

Charlotte