Using a pass through query in access I am pulling data from a SQL Server view.
On the access side, it is converting several fields to currency automatically when it displays the data. It also formats it to two decimal places.
The view in SQL shows all values to four decimal places which is how I would like it to display in Access.
So in other words, a value in the view is 0.8169 but Access displays it as $0.82
Is there anything I can do to have the Access display retain the sql view format? Thanks.