Solved

Change datatype to percent in VBA for existing table

Posted on 2008-10-03
2
608 Views
Last Modified: 2013-11-25
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 ????
0
Comment
Question by:ssmith94015
2 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 22636453
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
 

Author Comment

by:ssmith94015
ID: 22636893
OK, that would explain it.  In my result set then I can format as percent.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question