eliminate decimal in export

D

DumbCluck

I have a decimal field that I rounded and exported (text). It comes through
on the export with the decimal. I tried INT, CInt, CStr and tried converting
to a string and stripping off the period with MID. Nothing I tried works.
Can someone please point me in the right direction.
regards. Access 2003
 
J

Jerry Whittle

What are you exporting: a table or a query?

If a query, show the SQL statement.

How are you doing the export: code, macro, maually?

Are you using an export specification.

Please show some of the data before and after the export.
 

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

Similar Threads

Export decimals to txt 7
Export numeric field to text file with 5 decimal places 2
Export Results of Access 2000 query to text file. 2
export to csv - can t get rid of decimal 3
Decimal Hell 3
Access 97 Export to text dropping decimal spaces 4
Export to fixed in 2007 - bug? 4
column header problem when exporting -- need # character 4

Top