Exporting to text file

J

JoAnna

I'm exporting to a text file, I have the specs set based on col width. I
have a col that I want to round up. When I view the text file the number has
been rounded up but the decimal is still there with 00's
 
R

Roger Carlson

Create a query that formats the number the way you want it, and export that
query.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportFormattedFixed.MDB" which illustrates how to do this.
You can download it for free here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=351

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

exporting as text cutting off significant digits 2
exporting to text need decimals 1
Text columns exporting to currency columns 5
Export delimited text file 1
export teble to text keeping number format 2
Export to fixed in 2007 - bug? 4
Export from Access to Text file: Specified number of decimal place 1
exporting to text file 1

Top