Change datatype to percent in VBA for existing table

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 ????
ssmith94015Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Patrick MatthewsConnect With a Mentor Commented:
ssmith94015 said:
>>but I need to alter the datatype to percent and simply cannot find any samples

There is no data type for that.  Use Single or Double instead.
0
 
ssmith94015Author Commented:
OK, that would explain it.  In my result set then I can format as percent.
0
All Courses

From novice to tech pro — start learning today.