Access: Convert String to Double

[sabascal]

Hi,
I am querying a table with 1! column.
In this column, there are strings and number (which format is string).
I want to query this table, filtering text fields and summing the numeric one.
Probleme even for numbers, format is string.

what built in function can i use to convert the numbers (string format) into numeric format

 

[TonyJollans]

Hi sabascal,

Not quite sure what you want to do with the text values, but this should sum the numeric ones ..

[tt][blue] SELECT Sum(CDbl(YourColumn))
FROM YourTable
WHERE IsNumeric(YourColumn)[/blue][/tt]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.