Solved

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

Posted on 2008-10-15
6
306 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ms/access ftp / SFTP 3 32
Access Runtime 2010 Error 17 29
Storing Combo Box Selection in Table 12 42
MS access report - how to make a heading be zero when no data exists 17 32
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now