Change Field Type in a Query

[chanman525]

I have a make table query that is pulling information from multiple tables. The one field is pulling up to be a text field, but I need it to be a number field. I've looked in the properties of that field but I can't seem to find anything that changes it from a text field to a number field. Any help is greatly appreciated.

Thanks.

Alg

 

[PHV]

You may use a conversion function like Val, CLng, CDbl, CDec, ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[chanman525]

Well, the issue with Val is that the entire string is a number, but the field has leading 0's that we're trying to eliminate. By changing it from a text field to a number field, the leading 0's disappear.

I've tried to use a delete query and an append query, but I then get a data type mismatch because it's a text field going into a number field.

 

[lespaul]

but the field has leading 0's that we're trying to eliminate. By changing it from a text field to a number field, the leading 0's disappear.

so you eliminate the leading zeros just like you said you wanted to....what's the problem with that?

Leslie

Come join me at New Mexico Linux Fest!

 

[chanman525]

Nothing is wrong with that, but I'm not figuring out how to exactly change it from a text field to a number field, which would make the leading 0's disappear.

 

[JoeAtWork]

What you said is:
1. You want to convert it into a number
2. You want to get rid of the leading zeros
3. The problem with using Val to convert it into a number is that it gets rid of the leading zeros

????????????

 

[chanman525]

My fault, I wasn't very clear I guess. I got Int to work to change it to number.

Thanks for the help everyone.