Adding Columns in a Query

[racefan91]

I am trying to do some calculations in a query but can't figure out why it's doing things this way. When I added Total Wins + Total Losses to get Total Matches it works fine but now when I try to add Round One Wins + Round One Losses it doesn't seem to work. To me it looks like it putting the two numbers next to each other instead of doing the addition. This is what I put in the field name:



Total Round One Matches: [Round One Wins]+[Round One Losses]



Any help is greatly appreciated.

[Bob Fitz]

You might try:
Int([Round One Wins])+Int([Round One Losses])

[racefan91]

Brilliant! That did the trick. Do you know why this formula needed the Int in front and my other formula to calculate the total didn't?

[Bob Fitz]

I think it may be because one or both of the fields are data type text in the table. When you look at the data in the columns they are left justified but numbers are usually right justified.

[racefan91]

Is that something that can be changed in a crosstab query? I used one on my table to calculate the wins. Or can that be changed in my new query in which i pulled the "numbers" from the crosstab?

[Bob Fitz]

If you want to change the data type of the fields you would need to do that in the table.