Solved

6 decimals

Posted on 2011-09-25
4
395 Views
Last Modified: 2012-05-12
Everytime I export a table to text, I can not make Access export more than 2 decimal places  

I need to export 6 decimal places    Does anyone have a solution to this?
0
Comment
Question by:JackJackson54
  • 2
4 Comments
 

Expert Comment

by:mpkhan
ID: 36595124
Select the table
right click
choose numbers [ you will see decimals e.g. =2 ]
increase to 6   or =>  

close . & check.

0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 36595215
As far as I know this cannot be done unless you select the "Export data with formatting and layout" option, which may give you more 'layout' than you really want.

I would suggest exporting to Excel and working with the data there, unless you have a unsurmountable reason to export to a text file.  Even if the data appears to have two digits in Excel, I believe the entire number is present and can be seen by adjusting the column formatting.
0
 

Author Comment

by:JackJackson54
ID: 36595263
I had tried the "Export with fomatting and Layout" and yes you are correct in that it gives you more layout

0
 

Author Closing Comment

by:JackJackson54
ID: 36595329
It worked in Excel  I
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
This article will show you how to use shortcut menus in the Access run-time environment.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

920 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

12 Experts available now in Live!

Get 1:1 Help Now