Reports

  • Thread starter Thread starter Mick
  • Start date Start date
M

Mick

Hi

Have a report built from a simple query in the form:

Score
45
34
45


Want to total these as part of the report. Can code it in VBA if I have
to but assume there is a way using expression builder to do this.

Am guessing the expression is something like

= sum([score]) but this returns a generic format error.

Any help appreciated

Mick
 
Is your Sum() text box in the Report Footer and not in the Page Footer? Page
Footer won't work.
 
Mick said:
Have a report built from a simple query in the form:

Score
45
34
45


Want to total these as part of the report. Can code it in VBA if I have
to but assume there is a way using expression builder to do this.

Am guessing the expression is something like

= sum([score]) but this returns a generic format error.
Click to expand...


No you can not code that in VBA, at least not in the way
most people think they can.

As long as score is a field in the report's record source
table, =Sum(score) should work. Maybe you have more going
on than what you've described so far??
 
Back
Top