Hey guys.
I have a recordset (ADODB) connectiing to our mainframe (cant link
direct to ODBC).
One of the numbers on mainframe is Premium amount.
When I Debug.Print the value of the Premium ( Debug.Print rs(1)), the
decimal is two characters to the right of where it should be. I
checked the data on the mainframe itself and it's fine.
I ran the same code that pulls from mainframe on a co-workers computer
and the decimal place is fine.
Examples
211.49 shows 2.11 on my computer.
7.34 shows .07 on my computer.
Thanks,
Brian
I have a recordset (ADODB) connectiing to our mainframe (cant link
direct to ODBC).
One of the numbers on mainframe is Premium amount.
When I Debug.Print the value of the Premium ( Debug.Print rs(1)), the
decimal is two characters to the right of where it should be. I
checked the data on the mainframe itself and it's fine.
I ran the same code that pulls from mainframe on a co-workers computer
and the decimal place is fine.
Examples
211.49 shows 2.11 on my computer.
7.34 shows .07 on my computer.
Thanks,
Brian