Exporting qry to DBF and changing the formating of the number columns

  • Thread starter Thread starter Josh Wexler
  • Start date Start date
J

Josh Wexler

I'm exporting a query to DBF IV. And it works fine, except that it
makes every number column 5 decimals. I need all of them to have zero
decimal places, except for two columns that i need to be 4 decimals.
Is there any way of specifying this during the export, or thru code,
or will i have to just deal with it and fix it manually.

Thanks
 
Try using the Format function (as opposed to setting the Format property) in
your query.
 
Back
Top