Solved

6 decimals

Posted on 2011-09-25
4
398 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

820 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