Change Field Properties with an Update query.

[justagrunt]

Is it possible to alter a fields property from a text field to a number field via an up date query.
One database "JobNumber" has an autonumber field where the alpha prefix is added in the format ie JN3131.
The other database a purchase order database has a refernce text field where numbers or text are entered into the field ie JN3131.
A query based on the latter database filters out the alphanumeric entries, which the update query removes the alpha prefix to give 3131.
When I try to develope a query based on the autonumber database with the databse which has a text field - naturally a miss match.
The idea is to use the job number database and find all purchase orders raised for that particular Job Number.
So I have to change the property of a made table from text to number.
Cheers
Regards
Bill

 

[lupins46]

You will have to add a new field to your table, then update the new field with the numeric part of the code and then delete the original field.

 

[PHV]

Have you tried something like this ?
ON JobNumber.AutoNumber = CLng(PurchaseOrders.CalculatedField)

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

 

[justagrunt]

Thanks To all,
Will implement and see.
warm Regards
Bill