Calculating a Percent Field in a Query

[TryTryAgain]

I'm using a query to calculate a field that I have defined as a percent format in the query. However, in the table the format remains blank and I have to go in and set it to a percent. Is there any way to force the format of the field in the table to a percent when running the query to create the table?

 

[Golom]

You will need to mess with the field properties after the field is created

db.Tabledefs("myTable").Fields("pct").Properties("Format") = "Percent"