Query: Column=string parsed, numeric datatype?

[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

 

[Craig Huggart]

Shelley:

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

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