export with formatting isn't formatted RRS feed

  • Question

  • in the query; the field property is Currency with 0 decimal.

    using a macro: Export with Formatting  … alas the decimals return & appear....  a misleading title indeed, not sure what formatting is referred to but apparently not field properties...

    thought I'd throw this out there - - - I guess I have to set up a literal calculated field in each case eliminating the decimals?  there's quite a few fields and would like to avoid if anything else is out there on the Access side....

    Monday, November 5, 2018 10:54 PM

All replies

  • Hi,

    Just curious... What do you get if you use ImportExportSpreadsheet instead?

    Monday, November 5, 2018 11:13 PM