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....
