numeric conversion

[Anne Lam]

A text field of Table A is copied to a numeric (decimal)
field of Table B via an INSERT statement embeded with a
SELECT statement. How do I do the conversion in the
SELECT statement?

TableA: "1.1"
TableB: 1.1

 

[Phobos]

CDbl([tblA.Fld])

P

 

[Steve Schapel]

Anne,

Use the Val() function, i.e. in your query it will be
Val([YourTextField])

- Steve Schapel, Microsoft Access MVP