1. Registered User
Join Date
Aug 2004
Posts
2

When in the query Design I am having problems, I am trying to do a simple sum of tow columns, but cant seem to get it to work, I can get it to subtract, multiply and everything else but when I try to add I have problems.
This is what I mean:
Every calculating type works besides addition
For instance:

Subtraction works, its subtracts poverty from family
Family Total: [FAMILY]-[pov] = family-poverty total
Result of this is Family Total: 33,145 - 2,513 = 30632 works fine

Multiplication works also
Family Total: [FAMILY]*[pov] = family * pov total
Result of this is Family Total: 33,145 * 2,513 = 83293385 works fine

BUT the problem is when I do this:
Family Total: [FAMILY]+[pov] = family number + Poverty number
Result of this is Family Total: 33,145 + 2,513 = 331452513 <<<this is what I dont get why instead of adding up the numbers does it just place the numbers next to each other, it works fine for every other type of calculation is there some simple step I am mising or something I am not doing?

I hope i gave enough info

2. Registered User
Join Date
Apr 2004
Posts
173
Access is confusing the + sign as the concatenation operator. I've never run into this myself. Have you tried the sum function of those two fields (I assume they are number types)

3. Registered User
Join Date
Aug 2004
Posts
2
Originally Posted by mmbosman
Access is confusing the + sign as the concatenation operator. I've never run into this myself. Have you tried the sum function of those two fields (I assume they are number types)
Turn out that I had the numbers defined as text and that is why everything worked but addition...thanks

4. Grand Poobah
Join Date
Sep 2003
Location
MI
Posts
3,713
Originally Posted by chevi97
Turn out that I had the numbers defined as text and that is why everything worked but addition...thanks
.. And how you fix that is change the types OR do: ...CDbl([FAMILY])+CDbl([pov]) ...

5. Registered User
Join Date
Aug 2004
Posts
2
Originally Posted by M Owen
.. And how you fix that is change the types OR do: ...CDbl([FAMILY])+CDbl([pov]) ...
Daym your good can I email you if I hit snags I am trying to develop a db with a ton of tables and what not and I am still a rookie I have a few people here at work who are pretty good but in case they cant figure it out can I just email you?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•