<div>
one way would be to export the values as text rather than numeric with the currency symbol
</div>


one way would be to export the values as text rather than numeric with the currency symbol

<div>
<div class="content wysiwyg-content">
I have a tabel in MS Access 2010 that I have set up a macro to export using a storedimportexport. &nbsp; When the export file is create (TXT) the trailing zeros are dropped from the amount. &nbsp; Example &nbsp;10.00 exports as 10. &nbsp;The table shows it as $10.00. &nbsp; The field is set to currency with two decimal places. &nbsp; &nbsp;<br />
<br />
In order to import the txt file to another financial software package it must have the trailing zeros. &nbsp;How can I correct this? &nbsp;Thanks!<br />
Mark<br />

</div>
</div>


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


Export Dropping trailing zeros

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.