Can not get Columns to add up

[WKU]

For whatever reason when I try to add up two columns in a query instead of adding up the two numbers it displays it as a text string. So if one column has a 5 and the other is a 2 I am looking for the calculated column to reflect 7, currently it is showing 5,2.

I have added up items in the past so I am unsure what the problem is



should be [rev bid amount 1]+[rev bid amount 2].

Please help

[Bob Fitz]

You could try:
CInt(rev bid amount 1])+CInt([rev bid amount 2])

[WKU]

Thank you so much that worked! What is CINT stand for?

[Bob Fitz]

CInt() is one of the many In Built functions available. See: http://www.techonthenet.com/access/functions/