Query convert text to decimal number

[4Wile]

Would like to convert text to a decimal number using query.
Text is 12345.65 converted to 12345.65(Real & Decimal number)
Like:
INSERT INTO Newtbl(TestNumb)
SELECT ???? [Oldtbl].[TestText] '???? I need expression
FROM OldTbl

 

[THoey]

I think you need to look up CDbl in the help... Terry M. Hoey

 

[4Wile]

I can't find a reference to CDbl..I am a Newbie..
I looked in Help, Access2000 developers handbook,
Visual Basic Super Bible...Cant find CDbl..????

 

[PaulF]

first of all, I've been able to append text data to a Numeric field (Field Size was Double) without having to do any conversion, so I don't understand the problem you are having. Terry's example was to use the CDbl or Convert to Double function which would have converted the text string type to a numeric double type. If you are concerned about Access dropping the trailing zero off of the Decimal places, simply change the Format for the Numeric Field To Fixed.

PaulF