Text feild to number field or vica verca?

[newbee2]

Is it possible to export a text feild to become a number feild usinG vba code?
If so how?
Reason.
2 separate tables one has a job number as text the other as number feild. The two will not link in a query.
Thoughts.
Thanks for ideas in advance
Bill

 

[Zion7]

SQL ALTER statement? Change the data type?
CInt()???

 

[justagrunt]

Thanks
Bill

 

[PHV]

The two will not link in a query
Really ?
What about a join condition like this ?
FROM Table1 INNER JOIN Table2 ON Table1.NumericField = Val(Table2.TextField)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[newbee2]

Cheers and Thanks
Bill