Hello, I am having trouble with my money data types. When my query produces results the money values are converted to a string data type; when exported to excel the results are exported to as text as well which makes the pivot tables function improperly. It doesn’t seem to be an issue with the INT data types.
See the attached screenshots.
TDA datatype issue.doc (97.5 KB)