Exporting fixed width

[Guest]

Im attempting to export some queries in ASCII format. The porblem Im having
is with my number fields. It automatically adds (.00) to the end of the
number How do I get the decimal place out? or pad the field with zero to
the right ? For example one of my fileds is hours, lets say there is 64 hrs
the field width is 5 so when I export it shows as ".64" because the system
the file is loading to automatically assumes the the 2 decimal placesI would
like it to read as 6400. Can anyone help me?

 

[tina]

if you're working exclusively with whole numbers, change the data type of
your fields to Integer or Long Integer.

hth

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), there is a small sample
database called: "ExportFormattedFixed.MDB", which illustrates how to do
that.

--
--Roger Carlson
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

 

[Guest]

Im not working exclusively with whole numbers. Is there a way to add zeros
to the right without the decimal?

 

[tina]

i have a feeling i'm leading you down the wrong path. i think you'll get
more expert help in this case if you follow Roger's suggestion, and reply to
his post if you run into further problems. good luck!

 

[Guest]

Thank you for directig me to your site, it was very helpful. I have an
expression adding the values from four different tables. How do I go about
formating this?