how to set data type to certain field in a Make Table

[bluemoon9]

Hi all,
I have this querry, when I run the query, it makes the table name "tmaCustome r", but I would like to set the field "TotalCompliant " as Text, instead of Number, any idea?
When the table has created after running the query, the field "TotalCompliant " was automatically set to "Number".

SELECT [qrycustomer #3].Facility,
       1 AS [Order],
       Format([MonthYear],"mmmm") AS [Month],
       DatePart("yyyy",[MonthYear]) AS [Year],
       "Compliant Observations" AS Items,
       [qryCustomer #3].TotalCompliant AS Result INTO tmaCustomer
FROM [qryCustomer #3];

thanks!

Bluemoon

[ajalwaysus]

Try:

SELECT [qrycustomer #3].Facility
, 1 AS [Order], Format([MonthYear],"mmmm") AS [Month]
, DatePart("yyyy",[MonthYear]) AS [Year]
, "Compliant Observations" AS Items
, CStr([qryCustomer #3].TotalCompliant) AS Result 
INTO tmaCustomer
FROM [qryCustomer #3];

and if this doesn't work, please post qryCustomer #3 code.

-AJ

[bluemoon9]

it worked very well.
thank you so much for your help.
Have a happy new year.

bluemoon