Hey Guys,
I've been setting up an ODBC connection to a table housed on a SQL server. I have a field in the table that contains a percentage value formated as decimal(10,4).
However, when I set up the ODBC connection in Access, it shows up as Currency and rounds off the value. I've tried numeric(10,4) and adding decimal spaces.
Any idea why this is happening? I've done this hundreds of times before and never seen this.
Thanks!