digitalxni
Registered User.
- Local time
- Today, 20:30
- Joined
- Nov 18, 2009
- Messages
- 42
Hi guys,
I've got a report that prints out a query and looks like this:
Age Group | Count
Under 1 23
1 Year 34
.
.
And I want to add a field at the end that totals up all of count. I've added a text box to the footer and tried using =Sum([CountOfDoB]) and by setting the text field to do a running sum over CountOfDob. The first gives me an error and the second only counts the first age group and gives a value of 23.
Any ideas what I'm doing wrong?
I've got a report that prints out a query and looks like this:
Age Group | Count
Under 1 23
1 Year 34
.
.
And I want to add a field at the end that totals up all of count. I've added a text box to the footer and tried using =Sum([CountOfDoB]) and by setting the text field to do a running sum over CountOfDob. The first gives me an error and the second only counts the first age group and gives a value of 23.
Any ideas what I'm doing wrong?