By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,222 Members | 1,730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,222 IT Pros & Developers. It's quick & easy.

Exporting to text file.

100+
P: 443
This is driving me nuts!!! I have a table that one of the columns is set as Double, Fixed, 3 digits. I try and export this to a .txt file for a backup using the docmd.transfertext command but when I look at the file I only have 2 digits. What am I doing wrong and how can I get this to export 3 digits.
Hopefully come one can give me an answer.
Thanks for all your help.
Feb 16 '10 #1

✓ answered by ADezii

  1. Create a Query based on your Table.
  2. Create a Calculated Field which Formats the [Double] Field to display 3 digits, something similar to:
    Expand|Select|Wrap|Line Numbers
    1. NewDouble: Format([Double],"#,#,#.000")
  3. Do not Show the original [Double] Field in the Output.
  4. Show the Formatted Field ([NewDouble]) in the Output.
  5. Used the Query in the TransferTtext Method and not the Table.

Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,638
  1. Create a Query based on your Table.
  2. Create a Calculated Field which Formats the [Double] Field to display 3 digits, something similar to:
    Expand|Select|Wrap|Line Numbers
    1. NewDouble: Format([Double],"#,#,#.000")
  3. Do not Show the original [Double] Field in the Output.
  4. Show the Formatted Field ([NewDouble]) in the Output.
  5. Used the Query in the TransferTtext Method and not the Table.
Feb 16 '10 #2

100+
P: 443
That worked great thanks for the help.
Feb 17 '10 #3

100+
P: 443
Thanks for the help.
Feb 17 '10 #4

ADezii
Expert 5K+
P: 8,638
You are quite welcome, CD Tom.
Feb 17 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.