Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    6

    Exclamation Unanswered: Export Spec bug!!!

    Hi,

    I'm exporting a query to .txt. The spec I use is supposed to export a couple of 'Double' size fields. The problem is that it chopps off any digits in the 100ths or less range. EG Files Total Value = 10233769.830961 but when I export it to the txt file I get 10233769.83. This looks like a bug to me - any one know of a fix.

    Many thanks,
    Fergal

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Check this out - I think it will help

    http://support.microsoft.com/default...b;en-us;208408

    ACC2000: Exporting to Text File Truncates to Two Decimals Places
    (208408) - If you have a table that contains a Number field with more than two decimal places, and you export the table to a text file, the decimal places are truncated to two positions.

    HTH

  3. #3
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    6

    Thank you asxprog

    Originally posted by axsprog
    Check this out - I think it will help

    http://support.microsoft.com/default...b;en-us;208408

    ACC2000: Exporting to Text File Truncates to Two Decimals Places
    (208408) - If you have a table that contains a Number field with more than two decimal places, and you export the table to a text file, the decimal places are truncated to two positions.

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •