Adding Up

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:
 
Sounds like your "numbers" are actually text and it's just concatenating them (which + does with strings).
 
I have checked the tables they come from and the fields are set up as number format.

The query that goes into them has the property setting of General Number. I dont know what else I can do? Any Suggestions??
 
Compact your database, zip it and post it here so we can take a look. The max size when zipped is 393Kb.
 
Try this, it will make sure they are read as numbers and not text:-

=Int([Number1])+Int([Number2])
 
You are a star!!!!! saving me a lot of time as my db is HUUUUGGGGE!!! and still trying to compress it.

Many Thanks
 
I'm still concerned as, yes it will ensure that they are numbers, but it shouldn't be necessary and there is something "not right" going on. Sometimes "band-aid fixes" are not appropriate as they can mask a true problem that can come back and bite you later.
 

Users who are viewing this thread

Back
Top Bottom