troubleshooting Question

Export Dropping trailing zeros

Avatar of NetserMA
NetserMA asked on
Microsoft Access
2 Comments1 Solution486 ViewsLast Modified:
I have a tabel in MS Access 2010 that I have set up a macro to export using a storedimportexport.   When the export file is create (TXT) the trailing zeros are dropped from the amount.   Example  10.00 exports as 10.  The table shows it as $10.00.   The field is set to currency with two decimal places.    

In order to import the txt file to another financial software package it must have the trailing zeros.  How can I correct this?  Thanks!
Mark
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros