By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,399 Members | 1,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,399 IT Pros & Developers. It's quick & easy.

SUM of a text box in Access Reports

P: n/a
Hello everyone.

I have created a report that runs off a query. The query will return
results that have different records for different people but will only
have one (staff time) see query results below.
FIRSTNAME SUB_TEAM_1 QUEUENAME Actual_Time Staff
Aryn Heather Williams 1.245
10.09
Aryn Heather Williams UNDERWRITING 1.222
10.09
Anne Miranda Wilkins 0.426666666666667 7.598
Anne Miranda Wilkins SET UP 0.632222222222222 7.598
Anne Miranda Wilkins UNDERWRITING 2.35194444444444 7.598
Angel Miranda Wilkins 1.50055555555556 9.09
Angel Miranda Wilkins UNDERWRITING 3.36888888888889 9.09
Cindy Stephanie Becker 1.12361111111111 10.48
Cindy Stephanie Becker PAYMENTS 4.185 10.48
Cindy Stephanie Becker UNDERWRITING 0.285277777777778 10.48

Then i run a report off of this query. On the sub_team_1 footer i want
to total the staff hours for each Sub Team. However since there are
more than one record for each person, the staff time is sometimes
doubled/tripled when I do a sum so I cant go that route. Onthe
firstname footer i have a textbox with [Staff] that give me their staff
hours only once. When i try to sum up all of the values of the staff
textbox it asks for a value for Text115 which i named the Staff textbox
to. Is it possible to sum up a TextBox in the first place? Is there
anyway around this?

My control source is: =Sum([Text115]).

Please let me know if you would like to have more details.

thanks
Phil

Nov 30 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Phil:

I think you need to add a second unbound text box in your FIRSTNAME
footer with its control source as [Staff], and then turn on the Running
Sum property to Over Group. Name it TotalStaff. That should cause
Access to calculate a running sum for you, but only each time it hits a
new FIRSTNAME footer in your report. Once you've confirmed that it's
doing what you want it to, then set the Visible property to No (so it
doesn't show up on your report in the FIRSTNAME footer) and then add
another text field whose control source is =[TotalStaff] somewhere in
the report that is below the TotalStaff field. (If you put it
somewhere in the report above the TotalStaff field, it won't have
finished the running total for you.)

HTH,
Jana
ph*******@gmail.com wrote:
Hello everyone.

I have created a report that runs off a query. The query will return
results that have different records for different people but will only
have one (staff time) see query results below.
FIRSTNAME SUB_TEAM_1 QUEUENAME Actual_Time Staff
Aryn Heather Williams 1.245
10.09
Aryn Heather Williams UNDERWRITING 1.222
10.09
Anne Miranda Wilkins 0.426666666666667 7.598
Anne Miranda Wilkins SET UP 0.632222222222222 7.598
Anne Miranda Wilkins UNDERWRITING 2.35194444444444 7.598
Angel Miranda Wilkins 1.50055555555556 9.09
Angel Miranda Wilkins UNDERWRITING 3.36888888888889 9.09
Cindy Stephanie Becker 1.12361111111111 10.48
Cindy Stephanie Becker PAYMENTS 4.185 10.48
Cindy Stephanie Becker UNDERWRITING 0.285277777777778 10.48

Then i run a report off of this query. On the sub_team_1 footer i want
to total the staff hours for each Sub Team. However since there are
more than one record for each person, the staff time is sometimes
doubled/tripled when I do a sum so I cant go that route. Onthe
firstname footer i have a textbox with [Staff] that give me their staff
hours only once. When i try to sum up all of the values of the staff
textbox it asks for a value for Text115 which i named the Staff textbox
to. Is it possible to sum up a TextBox in the first place? Is there
anyway around this?

My control source is: =Sum([Text115]).

Please let me know if you would like to have more details.

thanks
Phil
Dec 1 '06 #2

P: n/a
.... and a month later i finally use this. HELPED ALOT!! THANKS!
Jana wrote:
Phil:

I think you need to add a second unbound text box in your FIRSTNAME
footer with its control source as [Staff], and then turn on the Running
Sum property to Over Group. Name it TotalStaff. That should cause
Access to calculate a running sum for you, but only each time it hits a
new FIRSTNAME footer in your report. Once you've confirmed that it's
doing what you want it to, then set the Visible property to No (so it
doesn't show up on your report in the FIRSTNAME footer) and then add
another text field whose control source is =[TotalStaff] somewhere in
the report that is below the TotalStaff field. (If you put it
somewhere in the report above the TotalStaff field, it won't have
finished the running total for you.)

HTH,
Jana
ph*******@gmail.com wrote:
Hello everyone.

I have created a report that runs off a query. The query will return
results that have different records for different people but will only
have one (staff time) see query results below.
FIRSTNAME SUB_TEAM_1 QUEUENAME Actual_Time Staff
Aryn 1.245
10.09
Aryn UNDERWRITING 1.222
10.09
Anne 0.426666666666667 7.598
Anne SET UP 0.632222222222222 7.598
Anne UNDERWRITING 2.35194444444444 7.598
Angel 1.50055555555556 9.09
Angel UNDERWRITING 3.36888888888889 9.09
Cindy 1.12361111111111 10.48
Cindy PAYMENTS 4.185 10.48
Cindy UNDERWRITING 0.285277777777778 10.48

Then i run a report off of this query. On the sub_team_1 footer i want
to total the staff hours for each Sub Team. However since there are
more than one record for each person, the staff time is sometimes
doubled/tripled when I do a sum so I cant go that route. Onthe
firstname footer i have a textbox with [Staff] that give me their staff
hours only once. When i try to sum up all of the values of the staff
textbox it asks for a value for Text115 which i named the Staff textbox
to. Is it possible to sum up a TextBox in the first place? Is there
anyway around this?

My control source is: =Sum([Text115]).

Please let me know if you would like to have more details.

thanks
Phil
Jan 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.