Quote Originally Posted by Cleetus View Post
What would we change to make it a number rather than text?
If the destination field is numeric then it will be a number. If there are values that cannot be converted I'd probably do something like
UPDATE [mytable] SET [mytable].[mynumcolumn] = Cdbl(mytxtcolumn) WHERE IsNumeric(mytextcolumn)=true
That will explicitly convert to a double type where the text field can be interpreted as number. See which values don't convert
SELECT * FROM [mytable] WHERE IsNumeric(mytextcolumn)=false
As before check for failed conversions looking for null just in case...

I hate Access. It uses a proprietary SQL wannabe implementation. Everything is much easier in plain SQL.