Solved

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

Posted on 2008-10-15
6
307 Views
Last Modified: 2013-11-25
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
Comment
Question by:ssmith94015
  • 3
  • 2
6 Comments
 
LVL 6

Expert Comment

by:thebradnetwork
ID: 22727312
0
 

Author Comment

by:ssmith94015
ID: 22727386
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
 
LVL 6

Accepted Solution

by:
thebradnetwork earned 500 total points
ID: 22727401
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 18

Expert Comment

by:jmoss111
ID: 22729030
The decimal set to 2 doesn't actually change the value of the column, it only changes whats displayed.
0
 

Author Comment

by:ssmith94015
ID: 22729302
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
 

Author Closing Comment

by:ssmith94015
ID: 31506579
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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…

808 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