Update Numeric field to Text in Make Table Qry 2

[JimStrand]

I have a make table query containing a 3 digit numeric field which I would like to update to text. How do I convert this to text in the Make Table Query? I've tried placing Format([numericField],000) in the property sheet of the field but this does not work. Any suggestions for handling this in the Make Table Query or in a subsequent update query if necessary Thank you.

 

[PHV]

What is your actual SQL code and which field should be converted ?

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

 

[JimStrand]

SELECT dbo_Monthly_Branch_Forecast.Branch INTO FCST_test
FROM dbo_Monthly_Branch_Forecast;

 

[dhookom]

I would try add a zero-length-string

SELECT dbo_Monthly_Branch_Forecast.Branch & ""
INTO FCST_test
FROM dbo_Monthly_Branch_Forecast;

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

Or this:

SELECT Format(Branch,'000') AS strBranch
INTO FCST_test
FROM dbo_Monthly_Branch_Forecast

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