Summarizing calculated field in a form (1 Viewer)

mracz001

New member
Local time
Today, 19:08
Joined
Apr 4, 2019
Messages
3
Dear Members.

Why not possible to Sum calculated field in the footer of a subform?
Example:
There is a product order 10000 pcs, which is delivered couple times.
One pallet contains 100 produts.
One occasion the lorry takes for example 12 pallets.
Form ORDER contains subform DELIVERY.
PALLETPCS is a field in DELIVERY table.
In the footer of subform Sum([PALLETPCS]) will work.

If I have a calculated field like PRODUCTPCS = PALLETPCS * 100
then Sum([PRODUCTPCS]) will show #Error

In fact Sum([PALLETPCS]) will also show #Error

I do not understand this. Why?? :confused:

Question:
How can I summarize a calculated data in the footer of a subform??
Please help. Thank you
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:08
Joined
Oct 29, 2018
Messages
21,358
Hi. Actually, it's possible to sum a calculated value, you just have to calculate it again. For example, if you had something like:
Code:
PALLETPCS: [PRODUCTPCS] * 100
And doing something like this doesn't work:
Code:
Sum([PALLETPCS])
Then, try doing it this way instead:
Code:
Sum([PRODUCTPCS]*100)
Hope that helps...
 

Users who are viewing this thread

Top Bottom