Report Sums of Sums

  • Thread starter Thread starter SNCONC
  • Start date Start date
S

SNCONC

Problem in a speiel - I have manhours that are entered in each day, a person
may work 10 hrs as his total manpower qty with thoe 10 hrs spread out in 5
different works areas. I neeed to run a report ach week which will tally up
te hrs in each area worked for the date group header, trade header &
classification header and also a sub total in eachgroup. The report style
has been created in Access 2000 and I have copied exactly the layout and
commands.
I need to show in each group the total of the sum fields added together and
repeat again for each different group and then a grand total at the report
footer.
The report works with the sums for each work area totals but the sub total
and grand total is not showing at all in each group.
I have a report with fields collected from a Table with data exported from a
program called Prolog (meridan systems), control source is the table
The report has a parameter prompt for a date range, Between [Start Date] And
[finish date]
The report has 3 groups each with the exact same "sum of fields" from
entries in the table.
The report footer has also a sum field for each column

ie 001label 002label 003label Total Label
Date Sumofarea01 - sumofarea02-sumofarea03 =sum([001]+[002]+[003])
Trade "
Classifation "

Basically the total sum of the sum fields is not showing anything at all no
error message or anything just blank. It is the exact same as the 2000 report
style, when the 2000 report style is run it is fine and works. Once I have
one goup working I can then just repeat for each one.
I need to check the grand totals at the report footer for the total manhours
entered against the hrs split into each area.
Please help!! Access for dummies was no help to me and I have been stuck on
this for 1 week racking my brain, I cansend examples if I am unclear as I am
still new to Access.
 
It's difficult to understand what your exact fields are, their data types,
and if they might be null. If you have three numeric fields [001], [002], and
[003] in your report's record source, you can sum the total of these in any
Group or Report Header or Footer section with an expression like:
=Sum([001] + [002] + [003])
If any of these might be null, you must change the expression to:
=Sum(Nz([001],0) + Nz([002],0) + Nz([003],0))
Keep in mind, you can't do this in a Page section.
 
Back
Top