Suming numbers and text together

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I have a problem. I have a table with a text field that was set up wrong
from the start.

The table looks like this.

Feild1
________
1
2
1
2
2 reserved
4 Res
2
1
3 res

I would like to sum the numbers but the text kills it. Is their a way to
have the query see only the numbers only?

Please Help..

Adam
 
I have a problem. I have a table with a text field that was set up wrong
from the start.

The table looks like this.

Feild1
________
1
2
1
2
2 reserved
4 Res
2
1
3 res

I would like to sum the numbers but the text kills it. Is their a way to
have the query see only the numbers only?

Please Help..

Adam
Click to expand...

Sum(Val([FieldName])) = 18 using the above data.
 
Adam said:
I have a problem. I have a table with a text field that was set up wrong
from the start.

The table looks like this.

Feild1
________
1
2
1
2
2 reserved
4 Res
2
1
3 res

I would like to sum the numbers but the text kills it. Is their a way to
have the query see only the numbers only?
Click to expand...


Try using the Val function:

Total: Sum(Val(field1))
 
Back
Top