That seems to have corrected the problem. Big thank you Steve!!

It came back with the same error. I wish it wasn't so generic. Maybe there's some problem at the linked server although it seems to work on other tables

Still getting the generic error

At minimum it is 0.000000000 at maximum is 1275000.000000000
There will never be anything other than zeros to the right of the decimal but there will always be at least a zero...

This is the largest data string in the table for that field. 1275000.000000000. MS Access shows it as text but in the progress database it is shown as decimal with format...

It shows as short text when using MS Access. I'm not sure how to code it with OPENQUERY. Ultimately it needs to be a number as all data in this...