Solved

Change datatype to percent in VBA for existing table

Posted on 2008-10-03
2
636 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

623 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