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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Josh Wexler - 16 Jul 2007 13:51 GMT

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

Reply to this Message

Douglas J. Steele - 16 Jul 2007 14:04 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> 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
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message