Re: Fixing the extract table problem

Hi Tom,

use a query to do your export

field --> Fieldname_ : format([fieldname],"#,##0.000")

where the columnname is the fieldname with an underscore after it -- still looks like the fieldname but is actually different ;)


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



CD Tom wrote:
I posted an earlier question regarding the extracting for a table that has number fields with 3 decimals, and when you extract the table to a .txt file only 2 decimals will come across. When you do the extract using the export command you can see that the field shows the 3 decimals but after the extract only 2 are in the .txt file. The only way I was able to resolve this problem was to go into the control panel of Windows XP and select the date,time, language settings the the regional and language option and customize the Number section to 3 decimals. Now for my question is there any way to change that automatically using code. I have customers using the export function to backup there data and if they have a problem to send me the backed up .txt files. I would like to be able to change the number and then change it back after the export is done. Hopefully someone out there will have some kind of an answer.
Thanks in advance for any help.

CD Tom
.

Relevant Pages

  • Re: OT: Quiz/QSHOW extract of packed decimals
    ... You can use the TIPS product to extract and format packed decimals for exporting to ... I am trying to extract some data using QSHOW from KSAM and TURBOIMAGE ... To join/leave the list, search archives, change list settings, * ...
    (comp.sys.hp.mpe)
  • RE: Extracting a numbers from a text string
    ... up to 2 decimal places - or no decimals like in the example. ... "IPerlovsky" wrote: ... See the example of the text string below: ... I am trying to extract the number "8". ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Extracting a numbers from a text string
    ... "IPerlovsky" wrote: ... up to 2 decimal places - or no decimals like in the example. ... See the example of the text string below: ... I am trying to extract the number "8". ...
    (microsoft.public.excel.worksheet.functions)
  • Re: doubles are rounded when exporing to ASCII
    ... One approach might be to use a query to extract the rows you wish ... You can use the query to set the decimal places. ... > use the built-in export function, but the output has been rounded to 2 ... > decimals. ...
    (microsoft.public.access.externaldata)
  • Re: Decimal places in combo boxes
    ... > I have a table that has a number fields, latitude, that is ... > decimals but they all show up as the 2 digit decimals. ... instead of [FieldName]. ... Please only reply to this newsgroup. ...
    (microsoft.public.access.formscoding)
Loading