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.
 

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

Top