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.)
