<div>
OK, that would explain it. &nbsp;In my result set then I can format as percent.
</div>


OK, that would explain it.  In my result set then I can format as percent.

<div>
<div class="content wysiwyg-content">
I have a table that is created in code, but I need to alter the datatype to percent and simply cannot find any samples &nbsp;Below is what I have<br />
ALTER TABLE ProdDataUserProductivity ALTER COLUMN Productivity ????
</div>
</div>


I have a table that is created in code, but I need to alter the datatype to percent and simply cannot find any samples  Below is what I have
ALTER TABLE ProdDataUserProductivity ALTER COLUMN Productivity ????

Change datatype to percent in VBA for existing table

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.