Exporting to text format

  • Thread starter Thread starter Yui
  • Start date Start date
Y

Yui

I am exporting database file to text(tab delimited)
format, and it cuts off at two decimal degrees. I need
all four decimal places. How do I fix that? For
exmaple, it shows, 2.32...I want 2.32456.
 
If your field is character based and needs to be right justified try:
Field: MyRightText: Right$(Space(10) & MyField,10)

If your field is numeric and needs leading zeroes use a similar technique to
return leading zeroes.
Field: MyRightText: Right$("0000000000" & MyField,10)

For decimal problems:
Create a query with the fields that you want to export and use the Format()
function to specify the number of decimal places in the number field. For
example, if your field has 4 decimal places, the column in the query grid
would look as follows:

Field: Format([MyField],"##0.0000")
 
Back
Top