eliminate decimal in export

  • Thread starter Thread starter DumbCluck
  • Start date Start date
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
 
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.
 
Back
Top