1) Adding New Band/Section to a report 2) #Error Mesg

  • Thread starter Thread starter Manuel
  • Start date Start date
M

Manuel

I have two questions:

1) How do I add another Detail Band/Section to my report?

2) Why do I keep getting an #Error message (when I switch
from design view to preview mode) when I insert count or
sum functions. I'm counting off a field in the report, so
I don't understand why I'm getting the error. I'm using a
text box, and then putting an expression in the control -
maybe I should be using a label instead?

Any help would be much appreciated.

Thanks,

Manuel
 
A1. New section
In report design view, open the Sorting and Grouping dialog (View menu).
Select the field you wish to group by, and in the lower pane of the dialog
set the Group Header and/or Group Footer to Yes. Note that you cannot create
new sections at runtime--only in design view.

A2 #Error
- The text box cannot be in the Page Header or Page Footer section.
- The expression in the text box must begin with the equal sign.
- What you are trying to sum must be a field in the report's RecordSource.
It cannot be the name of a calculated control on the report.
 
Back
Top