I've got a table, tblEmployees, with a field EmployeeNumber.  It's the primary key.

Data Type:  Number
Field Size: Double
Format: 00000000
Decimal Places:  0

Then I've got a query with fields

LastName
FirstName
EmployeeNumber

I export this as a text file using the Export Wizard, comma delimited.  In the preview in the Export Wizard window, the EmployeeNumber field shows with 8 digits, just as it should (with no decimal places).  However, in the resulting text file, every EmployeeNumber has ".00" tacked-on to the end.  E.g.:

Smith, Bob, 12345678.00
Smith, Bubba, 00123456.00
Jones, Bob, 01234567.00

How do I prevent the decimal places in the text file?  I tried setting the Format property on the field in the query to "Fixed" with 0 decimal places, but this has no impact.  Also set the Format property in the table to "Fixed."  No impact.

Any ideas would be appreciated.

thx

Hi David, I suggest you post this issue to Access for Dveloper Forum to get help.

The link of Access Forum: https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

That forum suits your issue and you can get more professional answers there.

SE13

• Edited by SE13KJ1S 5 hours 34 minutes ago

Hi David, I suggest you post this issue to Access for Dveloper Forum to get help.

The link of Access Forum: https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

That forum suits your issue and you can get more professional answers there.

SE13

• Edited by SE13KJ1S Monday, May 18, 2015 1:56 AM
• Marked as answer by David_H_3 16 hours 4 minutes ago

Hi David, I suggest you post this issue to Access for Dveloper Forum to get help.

The link of Access Forum: https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

That forum suits your issue and you can get more professional answers there.

SE13

• Edited by SE13KJ1S Monday, May 18, 2015 1:56 AM
• Marked as answer by David_H_3 Thursday, May 28, 2015 3:26 PM

Thanks for pointing me in the right direction!  I'd posted there once before & couldn't find the forum for some reason.