+ is Combining Numbers? (1 Viewer)

[SmallTomato]

So I have two numbers in a report that are looked up from a table with no conversion of any kind. They are looked up into report fields [prevmo_LA] and[Prevmo2_la]

14536 and 13464 are the values.

Using [prevmo_LA]+[Prevmo2_la] it just combines the numbers into 1453613464. How do I add them together? :banghead:

They subtract, multiply and divide with no issues.

 

[CJ_London]

looks like your numbers are not numbers but text

check your table for the field type and change to numbers. if you can't do that then try

clng([prevmo_LA])+clng([Prevmo2_la])

or

eval([prevmo_LA]+[Prevmo2_la])

 

[SmallTomato]

Yeah it is text grrr. Thanks, I didnt even think to check.

 

[SmallTomato]

All I am doing is running a make table query that combines information from tables where all the values are set to number and wrapping them in nz(,0) but my make query makes every field text. Any simple reason this would happen?

Or am I just wrong and somewhere something isn't what I think it is?

 

[CJ_London]

don't know, you could try taking off the nz function in your maketable query or design the table they way you want and use an append query instead