Access Export - Possible Rounding Problem

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters

Goal this month: 500 USD, Received: 115 USD (23%)

Related Topics...
Thread	Thread Starter	Forum	Replies	Last Post
Access Rounding Dollar Amount in Table	goose1521	Information Technology	1	28-Jul-2006 08:27 AM
Import/Export to SQL Server 2000 Problem	Frank	Information Technology	2	28-Jul-2006 08:17 AM
Access Document BLOB Export	Grandgousier	Information Technology	0	16-Nov-2005 14:50 PM
Rounding - Access 2000	Abay	Information Technology	12	05-Nov-2005 12:48 PM
How do I stop Access from rounding numbers?	MedicBiker	Information Technology	3	04-Nov-2005 15:19 PM

Tags

access, export, possible, rounding, problem

Stay Connected to Sikhism, Click Here to Register Now!

LinkBack

Tools

Display Modes

#1 (permalink)

28-Jul-2006, 08:37 AM

Chet Shaner

Guest

Posts: n/a

Access Export - Possible Rounding Problem

Donate Today! Tell a Friend Print Feedback

Register to Remove Advertisements

Have an Access db that we are exporting data to a CSV formatted file. Have
some fields in tables defined as Double data type (General Number, auto
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13531-access-export-possible-rounding-problem.html
decimal). When exporting the data, getting strange rounding of the numbers,
some up and some down. If I change the defined data type to Single (General
Number, auto decimal) the exported data appears to be correct and correctly
formatted.

We are manipulating the data before export by queries and code. The only
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13531
mathematical operations are addition and subtraction.

Any Ideas?

*

Got anything to share on This Topic? Why not share your immediate thoughts/reaction with us! Login Now! or Sign Up Today! to share your views... Gurfateh!

Sponsored Links

Click Here to Donate Now!

Support Us! Become a Promoter!

Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!

Bookmarks

« Previous Thread | Next Thread »

(View-All) Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Tools	Search
Show Printable Version Email to Friend	Search: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is On Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

» Blog
I think Bran has killed Rory......... - (harry haller) Try anything once, Chazji here I come! - (harry haller) fuzzy - (harry haller) for ex madmen only - (harry haller) Daily Amrit Vela Blog - the difficulties, the joys, the methods of this practical journey to self discovery - (chazSingh)

» Active Discussions
Paneer: what I have... By Gyani Jarnail Singh Today 15:39 PM 1 Replies, 23 Views
Is Science a Religion? By Seeker9 Today 15:04 PM 12 Replies, 1,974 Views
Woolwich Killing: The... By Seeker9 Today 14:01 PM 16 Replies, 201 Views
How does Sikhi help you... By japjisahib04 Today 13:37 PM 45 Replies, 1,156 Views
Rochester Gurdwara... By Tejwant Singh Today 10:55 AM 2 Replies, 71 Views
US Congress panel passes... By spnadmin Today 04:22 AM 0 Replies, 40 Views
Harmeet Kaur Took the... By spnadmin Today 03:40 AM 0 Replies, 56 Views
Rozana Reports (ਪੰਜਾਬੀ... By spnadmin Today 01:43 AM 319 Replies, 7,698 Views
Sikh Spokesman (ਪੰਜਾਬੀ... By spnadmin Today 00:36 AM 182 Replies, 4,622 Views
Panjabi Alphabet Resource By dalsingh1zero1 Yesterday 23:15 PM 12 Replies, 6,559 Views
Transgenderism ... Right... By Brother Onam Yesterday 22:55 PM 30 Replies, 1,369 Views
Biography of a Scholar:... By spnadmin Yesterday 22:53 PM 1 Replies, 79 Views
Dusting The Web By spnadmin Yesterday 22:25 PM 0 Replies, 46 Views
How Pure the Tongue? New... By spnadmin Yesterday 21:29 PM 0 Replies, 63 Views
Stockholm riots throw... By spnadmin Yesterday 21:14 PM 1 Replies, 44 Views

» Books You Should Read...

All times are GMT +6.5. The time now is 16:20 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright © 2004-12, All Rights Reserved. Sikh Philosophy Network