Suming numbers and text together

[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

 

[fredg]

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

Sum(Val([FieldName])) = 18 using the above data.

 

[Marshall Barton]

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?

Try using the Val function:

Total: Sum(Val(field1))

 

[Adam]

Try using the Val function:

Total: Sum(Val(field1))

Thanks that worked...

Adam