Query: Column=string parsed, numeric datatype?

  • Thread starter Thread starter Shelley
  • Start date Start date
S

Shelley

I have a column in a query that contains the numeric characters of
another field in the same query. The field is text datatype, and i
want the new column to be numeric datatype. Is there any way to do
this without adding a new column to the table?

Thanks,
Shelley
 
Shelley:

You should be able to use the VAL function to do this.

Craig Huggart
Microsoft XP Master Instructor
(e-mail address removed)
 
Back
Top