• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

Need to alter a column in ACCESS 2003 in code to Double with two decimals

I have a talbe that is created in code.  It is double to hold percent.  But it stands at Auto for decimals - how to I tell it I want double with only two decimals points?

ALTER TABLE BudgetSales ALTER COLUMN Comp Double ????

This is reall urgent as I am in a crunch to get this out tonight!
0
ssmith94015
Asked:
ssmith94015
  • 3
  • 2
1 Solution
 
thebradnetworkCommented:
0
 
ssmith94015Author Commented:
Thank you, but not really.  The query that creates the table is written in VBA, not a query in the query grid so I need to make the alteration in VBA.
0
 
thebradnetworkCommented:
0
Independent Software Vendors: 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!

 
jmoss111Commented:
The decimal set to 2 doesn't actually change the value of the column, it only changes whats displayed.
0
 
ssmith94015Author Commented:
Sorry I took so long to get back.  Someone in the other building had a "problem" that needed to be addressed.  In otherwords - upper management wanted babysitting.

thebrednetwork, I checked the link out and that is exactly what I was looking for.  I created a procedure to call this and when it returns to the next command, the table is how I want it.  Thank you.

thank you also jmoss111 for your comment.
0
 
ssmith94015Author Commented:
Again, thank you.  I am getting very tired and this really saved me.  It is after 3:00 am here and I am finally getting out.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now