export to DBF without decimals?

[Eddie J]

This is driving me nuts - I'm trying to export my access table to dbaseIII
format. Most of the fields are text except for 2 of them which are
numbers. No matter what I try, the resulting exported file adds a decimal
and four "0" after the numbers. All the numbers in the table have no
decimal showing, nor should they. But 607 gets exported as 607.0000

I've tried everything I can think of - someone please tell me how to get
around this?

Thanks

[Tom van Stiphout]

On Thu, 10 Mar 2005 18:12:29 -0600, [e-mail] (Eddie J)
wrote:

Why would you? The value of 607 is equal to the value of 607.0000.
It's just a matter of formatting, which has to do with presentation,
NOT with the actual value.

-Tom.

This is driving me nuts - I'm trying to export my access table to dbaseIII
format. Most of the fields are text except for 2 of them which are
numbers. No matter what I try, the resulting exported file adds a decimal
and four "0" after the numbers. All the numbers in the table have no
decimal showing, nor should they. But 607 gets exported as 607.0000

I've tried everything I can think of - someone please tell me how to get
around this?

Thanks

[DFS]

Eddie J wrote:

This is driving me nuts - I'm trying to export my access table to
dbaseIII format. Most of the fields are text except for 2 of them
which are numbers. No matter what I try, the resulting exported file
adds a decimal and four "0" after the numbers. All the numbers in
the table have no decimal showing, nor should they. But 607 gets
exported as 607.0000

I've tried everything I can think of - someone please tell me how to
get around this?
Try exporting a query that formats the columns with no decimals.

Thanks

[Eddie J]

no****@DFS.com (DFS) wrote in <1A******************@fe07.lga>:

Eddie J wrote:

This is driving me nuts - I'm trying to export my access table to
dbaseIII format. Most of the fields are text except for 2 of them
which are numbers. No matter what I try, the resulting exported file
adds a decimal and four "0" after the numbers. All the numbers in
the table have no decimal showing, nor should they. But 607 gets
exported as 607.0000

I've tried everything I can think of - someone please tell me how to
get around this?

Try exporting a query that formats the columns with no decimals.

Can you give me some thought on how that is done?

Thanks much.

[Eddie J]

Sorry, disregard. Figured out with Format() function. Thanks again.

Try exporting a query that formats the columns with no decimals.

Can you give me some thought on how that is done?

Thanks much.