Total or pre calculated column

[Charlie]

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

 

[Duane Hookom]

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])

 

[Charlie]

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

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

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

 

[Duane Hookom]

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

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

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

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

 

[Charlie]

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

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

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]

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

--
Duane Hookom
Microsoft Access MVP

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

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

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