Total or pre calculated column

  • Thread starter Thread starter Charlie
  • Start date Start date
C

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
 
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])
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Did you try sum the expression like
=Sum((([PageCount]*[Qty])/[NumberOnSheet]*0.03)+([PageCount]*[Qty])/[NumberOnSheet]+0.5)

--
Duane Hookom
Microsoft Access MVP


Charlie said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top