numeric conversion

  • Thread starter Thread starter Anne Lam
  • Start date Start date
A

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
 
Anne,

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

- Steve Schapel, Microsoft Access MVP
 
Back
Top