MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. complex union query
    Hi every body I've a little problem with my query, I can't figure it out. I've three tables: Table A (EmployeNr, Date, Code) Table B (EmployeNr, Date, Code) Which is an historic of Table A Table C (BegD, EndD) I can have all the records in table A that doesn't match in table B but not from the other side. Table A Table B Table C 0001 0001 20031001 20031002 20030930 20031031 PR1 PR1 0001 0001 20031003 20031001 PR1 Mal 0001 20031003 PR1 The result expected is: 0001 20031001 PR1 0001 20031002 PR1 I need to get all the records In table A which aren't in Table B but also all the records in table B which aren't in table A but matching with the period in table C. Any suggestion will be greatly appreciated.
  • 2. email hyperlink fields?
    I have a field which contains email addresses. I would like to be able to click the email address field and have my email program open up to send a message to that address (like you can do with excel etc). Is there some property setting etc that will enable me to do this? I can only seem to create hyperlinks, but not email links. I'm using Access 2000 Thanks
  • 3. Account Receivables
    Good day to all, I'm trying to put together an invoicing system that uses AR. The database tracks daily and weekly services and I would like to be able to do some aging, apply partial payments and track histories. Any advice would be greatly appreciated. Thank you
  • 4. QUERY QUESTION: how to use form variable as criteria ??
    Hello. I have a question concerning variable criteria for queries and reading forms. Let's say that I have a table with 2 fields and 10 records. One of the fields can have two different values: A or B. Then let's say that I've designed a slpit form. The right side of the form allows for data entry while the left side allows for record filtering. On the left side, the user can activate a control box or radio box to choose between A and B records. As soon as he does that, the records are automatically filtered. I only know how to create critera with constants (criteria = "A") QUESTION ------------- The problems is this: How can I edit my query for it to look something like this: For field CHOICE, critera = comboChoice.Value from frmLeft I tried entereing this, and it gave me "=[frmLeft].[comboChoice].value" or something very close to this. Thanks for your help!
  • 5. MultiSelect Listbox trouble
    Hi I'm trying to use a multiselect listbox to limit records in a report. My version at work is 97 but now at home I'm using Access2002- I know I can't go backwards ( to use this or similar code at work) anyway: msListBox - listnames unbound report - rptD Code is from the Microsoft Access 97 Developer's handbook 'PILastFirst' is the keyfield selected in the listbox - the bound field from a query rptD depends on The button to view the report is has on the click event: Private Sub btnPreviewReport_Click() On Error GoTo Err_btnPreviewReport_Click Dim vntItem As Variant, strFilter As String Dim myReport As New Report_rptD For Each vntItem In Me!ListNames.ItemsSelected strFilter = strFilter & "[PILastFirst] = '" & Me![ListNames].ItemData(vntItem) & "' OR " Next If strFilter <> "" Then strFilter = Left(strFilter, Len(strFilter) - 4) DoCmd.OpenReport rptMyReport.Name, acViewPreview, , strFilter Else MsgBox "no data has been selected!", vbOKOnly End If Exit_btnPreviewReport_Click: Exit Sub Err_btnPreviewReport_Click: MsgBox Err.Description Resume Exit_btnPreviewReport_Click End Sub ------------------- I get a "user-defined type not defined" message that refers to the " Dim myReport As NEW Report_rptD " line What is NEW that appears in the Dim statement? THANKS in advance!! -warning e-mail address altered- arthureNOSPACE@

MS Access export to text file decimal round off problem

Postby brotherhou » Sun, 26 Oct 2003 07:13:54 GMT

It's found that when exporting a table/query to a text file, numbers
with decimals will be rounded off to 2 decimals (or 0 decimals
sometimes). Is there an explanation or setting for that?

Similar Threads:

1.Exporting Number with Decimals to Text Rounds to 1 decimal place

I have data in Access that I need to export to a text file.  This data has 4 
or more decimal places and when I export the data the text file ends up with 
rounded data to the first decimal place.  Please help:) 


2.Why Access export three decimal but in text file only two decimal

Can any Access 2003 gurus kindly please advice me on the reason why Access 
export table options exports to a text file involving number data type with 
three decimal places but resulting in only two decimal places in my text file 
content ? 
Is it a bug that causes the last decimal digit to be truncated or some 
settings that could help rectify this problem of mine ?

3.Decimal point rounded off when exporting.


I'm running into an issue when exporting a table to a .csv file. The table 
contains columns of numbers many of which contain a decimal point and three 
digits after the decimal. For example 5.123. The problem is that once the 
table has been exported to the .csv file the third number (the thousandth) 
has been rounded and I only get the hundredth (for example 5.12). Have tried 
Access 2002 and 2003 with the same results. The data type of the columns is 
Number, Field Size is Double, with Decimal Places set to Auto. Any 
suggestions? Thanks in advance for your help. 


4.Problems with DBase IV file exporting after converting frojm MS Access 97 to MS Access 2000

In our MS ACCESS 97 database that we have converted to a MS Access 2000
database.  In this application we transfer (TransferDataBase) a table  with
a memo field to DBase IV.  Our application uses the dbf and dbt files
generated to do some further manipulation.  The system works under MS Access
97 but does not under Ms Access 2000.

Is the dbf page size exported different in MS Access 2000?

Any other driver or parameter settings in MS Access that could be affecting

We also notice that the new MS Access transfer cmd produces a new file with
an MDX extension.  Can we get Access to work without this file?

Any help greatly appreciated.


5.Keep decimal places when exporting to text files from Access

6. Export from Access to Text file: Specified number of decimal place

7. import text file errors - cutting off decimals

8. form rounding off decimals

Return to MS ACCESS


Who is online

Users browsing this forum: No registered users and 77 guest