Solved

6 decimals

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

This article will show you how to use shortcut menus in the Access run-time environment.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

762 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

17 Experts available now in Live!

Get 1:1 Help Now