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

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
 
D

Douglas J. Steele

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