I don't know what the best solution for this is, but one thing I've tried that usually works is -- instead of exporting from the query view, write a make-table query in your application and then call that before you export. Usually, when you export from a table the fields will retain the right values. When you export from a query it can be an uncertain result.
--- In [email protected], "Marty" <[EMAIL PROTECTED]> wrote: > > I am stuck and need help. I was asked to help with a company project > that seemed simple enough. We are entering claims in a simple > database then each record is exported to a text file where it is > electronically transferred to the supplier and processed at their end > so we can receive our credit for the claim. Iam using the following > statement to create the text file: > > DoCmd.TransferText > acExportDelim, "EDI_Export", "qryFilteredEDIForRowCount", strPathFile > > Here is the problem I am having. On some of the records the value in > the quantity field, price field and Extension field are being > converted to scientific notation. I have tried changing the format > in those fields, changing the size from single to double to variant > with no luck. Can anyone tell me if I am doing something wrong or if > there is a setting in Access (I am using Access97) that will give me > the export without scientific notation? > > Thank you All > > Sidenote: (I have noticed if I set the field size as single and do > any calculation against that field it will actually change the value > of the field itself, eg I enter .0027 and multiply by 1 returns a > value of .002700000067003546.) >
