 <p>Use the query to store the raw quotients and adjust the field's <em>Format</em> property afterward.</p> <pre class="lang-sql prettyprint-override"><code>SELECT ([DB].[Number1] / DB.[Number2]) AS [New Column Name] INTO newTable FROM [OldTable] as DB; </code></pre> <p>You can open the table in Design View and choose <em>"Percent"</em> for the field's <em>Format</em>. If you want to do the same thing with VBA, I tested this in Access 2010:</p> <pre class="lang-vb prettyprint-override"><code>Dim db As DAO.Database Set db = CurrentDb With db.TableDefs("newTable").Fields("New Column Name") .Properties.Append .CreateProperty("Format", dbText, "Percent") End With </code></pre> <p>Another way to approach this would be to create the table, set the field format, and then use an "append query" (instead of a "make table query") to load your data into the table. </p>