• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

6 decimals

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
JackJackson54
Asked:
JackJackson54
  • 2
1 Solution
 
mpkhanCommented:
Select the table
right click
choose numbers [ you will see decimals e.g. =2 ]
increase to 6   or =>  

close . & check.

0
 
mbizupCommented:
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
 
JackJackson54Author Commented:
I had tried the "Export with fomatting and Layout" and yes you are correct in that it gives you more layout

0
 
JackJackson54Author Commented:
It worked in Excel  I
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now