MS Access export to text file decimal round off problem


    Sponsored Links


  • 1. Chart-Component Problems with NULL-Values and Linestyles
    Hi! Aaaaaaaaaaaaaargh M$! Please mention my following conclusions: Access 2002, Form with Chart-Component: I dynamically create and fill a table XY, afterwards adapt the RowSource of the Chart-Object and the styles of the separate series. Result is a chart with mixed Styles (two chartgroups), two Value-Axes,... Only troubles... Now, what I found out: 1) If you have a column (series) in your Rowsource-Dataset containing only NULL-Values customization of linestyle is foredoomed!!! 2) Not any of the linestyles in the linestyle-enumeration is valid. XLDouble and XLSlantDashDot cannot be assigned to series of style xlLine. Many hours lost with hacking and reading NGs. HTH you in advance Stefan ("much" wiser than 2 hours ago)
  • 2. Complex data validation
    I am working on a system that has something like 500 fields (in several tables of course) viewed/edited in several forms. Some fields will be reqiired entry (or required value range) based on entry/values in one or several other fields. Other than writing some really complex code, does anyone have a suggestion for a creating a managable validation system? Thanks, -- Alphonse Giambrone Email: XXXX@XXXXX.COM For email replace NOSPAM with agiam
  • 3. union query with a condition
    I have a some tables and a query: t1: Kid [integer] sum [integer] q1: SELECT tbl2.CsID, tbl2.AttID, tbl2.Count AS T1Count FROM tbl2; This query returns the Csid [integer] and its total count [integer] from table2. Table t1 may have Kid's that already exist in the query and some that don't. I would like to create another query (or to change q1) that will add to the recordset all Kid's that exist in t1 and do not exist in the result of q1 (Kid should be in the Csid field). Example: t1: Kid sum 1 3 2 1 3 1 q1 result: Csid T1Count 2 1 3 2 5 2 Merging q1 with the new query (or changing q1) should return: Csid T1Count 2 1 3 2 5 2 1 3 <- this record was added I guess a union query should be used here, but I need to define a condition that only NEW records (with Kid<>Csid) are added. Many thanks in advance, Dan.
  • 4. generating text in unbound text boxes--correction
    Silly mistake. It's been fixed. Basically the box wasn't unbound, it was linked to a field named "Unbound", which didn't exist. But thanks for all those that looked. -s "Sheel Ganatra" < XXXX@XXXXX.COM > wrote in message news:bf3had$38e$ XXXX@XXXXX.COM ... > My last e-mail had an incorrect subject line, so here goes again: > > I want some unbound text boxes in my form which lookup information about a > student (such as their address, etc.) from a "Students" table when the > Student's ID # is entered in this "Student Programs" table that I have. Say > one such text box is labeled "Add1" and is Unbound. > > Why doesn't this piece of code, put in the afterupdate portion of Student > ID, give me the Address of the Student? (it instead gives me a blank form) > > > Private Sub Student_ID_AfterUpdate() > Me.Add1 = DLookup("[Home address 1]", "Students", "[Student ID] = " & > Me.Student_ID) > End Sub > > [Home address 1] is the name of the field as it appears in the "Students" > table. Do I need to specifiy something about this textbox or make it unbound > to be able to display this information? Also, without storing this > information in "Student Programs", how do I make it automatically enter > every time I start the form? (and automatically enter every time I update > the student ID, of course) > > >
  • 5. Combo box based on a table - give same value
    Hi, I have a form which has subform. I added a combo box to this subform. The field is called SalesPerson each order has a sales person field so we can calculate comission attached to each order. This combo box is based on a table which has all the sales person name. The problem is when I select sales person from the drop down list, it changes to same sales person for all the order. I want each order as an independent event. how can I unlink them so if I chose different salesperson for second order then the first order stays the same. Thanks in advance

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 33 guest