When I export a currency field from Access to an XML file I lose any trailing zeros, any ideas how to stop this happening ?
When I export a currency field from Access to an XML file I lose any trailing zeros, any ideas how to stop this happening ?
You mean 2000 exports as 2? Test with field set to number instead of currency type.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.