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