Unicron1138
IS-IT--Management
I have created an ODBC linked table in my Access database to ARG_SalesCodeMasterfile in Mas90. Everything seems to work fine, except the last field in the table, StdPrice, is being truncated. I'm only shown two decimal places, when in fact these values have 5 decimal places. If I do the "Save Report as Excel document" option from within Mas90, I get the full 5 decimal places, but I can see when building the report that Mas90 references the source of this data as "AR.SALESCD"
So a.) am I using the right table to get this information (I need the SalesCode and StdPrice), and b.) if so, how do I get Access to show me all five decimal places? If I go to the properties for the field in Access and set it to show 5 decimal places, all it does it add on however many zeroes it takes to reach five digits. The value is truncated at 2 digits after the decimal place, not rounded.
So a.) am I using the right table to get this information (I need the SalesCode and StdPrice), and b.) if so, how do I get Access to show me all five decimal places? If I go to the properties for the field in Access and set it to show 5 decimal places, all it does it add on however many zeroes it takes to reach five digits. The value is truncated at 2 digits after the decimal place, not rounded.