|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 15th, 2008, 06:19 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Suming numbers and text together
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 
|
|
#2
July 15th, 2008, 07:01 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Suming numbers and text together
On Tue, 15 Jul 2008 10:19:03 -0700, Adam wrote:
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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#3
July 15th, 2008, 07:03 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Suming numbers and text together
Adam wrote:
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)) -- Marsh MVP [MS Access]
|
|
#4
July 16th, 2008, 01:33 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Suming numbers and text together
"Marshall Barton" wrote: Adam wrote: 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)) -- Marsh MVP [MS Access] Thanks that worked... Adam
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
