Sum in report

[deepucec9]

Created a new report with pallet number. But the total sum of pallet in report footer showing wrong.


Please check the attached screenshot. Instead of 1 toatal sum is showing as 6 .
format "Sum([pallet_out])"

TIA

[JamesDeckert]

It looks like you're grouping on the pallet, so each detail record would contain the pallet and since there are 6 records, you would sum to 6.
What is the field name for the master table? Use it instead of the name for the child table. Or if they're the same, then try sum([mastertable].[pallet_out])

[deepucec9]

Tried sum([mastertable].[pallet_out]) still the same result.
All fields are from same table "out".

[JamesDeckert]

Is there a query behind the report? If so, can you show it?
I'm not sure, but I think you may be able to sum the group control. e.g. sum([ctrlPallet]) or sum(cint([ctrlPallet]))

[HiTechCoach]

If you need to count groups ( each pallet is a grouping) then check this out:

http://access.mvps.org/access/reports/rpt0016.htm