#error with calculated field in report footer

  • Thread starter Thread starter Spidey3721
  • Start date Start date
S

Spidey3721

Can I use a calculated field in a report page footer?

I am trying to get a sum (textbox controlsource: "=sum([costs])" in the PAGE
FOOTER

But I'm getting a #ERROR

It appears as though I have the exact same setup that I have used on similar
FORMS - Also - When I cut and paste this sum textbox into the DETAIL section
of the report - it works, but it repeats with every COST that is listed - I
only want it at the bottom.

Also - Is there a way to break a report into sections, where I can have more
headers/footers ?
 
Read Microsoft KnowledgeBase article:
132017 'How to sum a column of numbers in a report by page'
 
You put the "=sum([costs])" in the page footer. This will
never work, what you should do is open the report footer
and place the same textbox with the same formula there and
it should work.
You can most certainly have a report with multiple
footers, the most common way of doing that is to use the
grouping/sorting properties of the report.
Right clicking the left top little square of the report
design view window will show a dropdown and if you select
the sorting/grouping option, you will see an other window
where you can sort and/or group data. Notice for each
grouping you can also select to have a separate header
and/or footer. I think after you check this out you'll be
happy with the many option provided.
Hope this helps.
Fons
 
I had a problem doing this when I had multiple grouping sections, one for
each group of forestry treatment. (doesn't matter what they were here). I
used several subreports to make the calculations and added the sums from the
subreports at the end of the page 'footer' (grouping footers were used). The
detail section was never used because of the multiple treatments. The report
listed the owner, treatment job #, area treated (which was summed by group
and overall total at the end) and location (geography). Some groups had 3
treatments per group. It was quite complicated, but I didn't have to write
any code ;)


Fons Ponsioen said:
You put the "=sum([costs])" in the page footer. This will
never work, what you should do is open the report footer
and place the same textbox with the same formula there and
it should work.
You can most certainly have a report with multiple
footers, the most common way of doing that is to use the
grouping/sorting properties of the report.
Right clicking the left top little square of the report
design view window will show a dropdown and if you select
the sorting/grouping option, you will see an other window
where you can sort and/or group data. Notice for each
grouping you can also select to have a separate header
and/or footer. I think after you check this out you'll be
happy with the many option provided.
Hope this helps.
Fons
-----Original Message-----
Can I use a calculated field in a report page footer?

I am trying to get a sum (textbox controlsource: "=sum ([costs])" in the PAGE
FOOTER

But I'm getting a #ERROR

It appears as though I have the exact same setup that I have used on similar
FORMS - Also - When I cut and paste this sum textbox into the DETAIL section
of the report - it works, but it repeats with every COST that is listed - I
only want it at the bottom.

Also - Is there a way to break a report into sections, where I can have more
headers/footers ?


.
Click to expand...
Click to expand...
 
Back
Top