Fifer
Registered User.
- Local time
- Today, 16:01
- Joined
- Dec 28, 2005
- Messages
- 31
This seems really silly but I cannot get this query to work.
In one table I have the agents name, id,Category, No of held emails and the time it took to put these emails on hold. In the other query I have the same agent details,category, No of reassigned emails and the total time it took to reassign these.
What I want the query to do is add the total time spent holding and email to the total time spent reasssigning by category.
What my query keeps doing, as I thought it would be as simple as adding them together is instead of ie:
130+1 = 131 it gives me 1301?????
The query is joined using Agent id and Category.
Help Please:
In one table I have the agents name, id,Category, No of held emails and the time it took to put these emails on hold. In the other query I have the same agent details,category, No of reassigned emails and the total time it took to reassign these.
What I want the query to do is add the total time spent holding and email to the total time spent reasssigning by category.
What my query keeps doing, as I thought it would be as simple as adding them together is instead of ie:
130+1 = 131 it gives me 1301?????
The query is joined using Agent id and Category.
Help Please: