query properties

[vicsaccess]

ok, here's a new one on me. I have a database linked to several individual databases. each database is exactly the same other than the tables names and i'm using a union query in the central DB


to bring it all together and I must say for the first time doing this its working great. ok here's the problem. one of the tables I believe is coming in with numbers displaying right justified and when I try to add them together they are trimming the numbers rather than adding? example column 1 is "5" and column 2 is "0" the result of adding them is "50"? the "5" & "0" trimmed. I have checked all my linked tables and they are all numbers, I did not change any properties in the union and when I try to pull up the properties for the query that I am using to add the two numbers together it does not show any available properties.

[CJ_London]

what does your sql look like?

[vicsaccess]

looks like a sql what am I looking for?

[CJ_London]

I presume you are using a query because you say this

any properties in the union and when I try to pull up the properties for the query