I have made a ODBC connection between NAVISION and Access.
When I run the query a number "23" shows up as "2300000".
I think the comma is not showing maybe because of setting problem.

I do not know how to fix this. 

In the Navsion database figures are correct.

sounds like a ODBC driver problem. Probably due to precision
see http://dynamicsuser.net/forums/t/6072.aspx


Pieter

"Remko Strik" <Remko Strik@discussions.microsoft.com> wrote in message 
news:F83F3871-DDCB-44E7-BC50-6CAD87659284@microsoft.com...
>I have made a ODBC connection between NAVISION and Access.
> When I run the query a number "23" shows up as "2300000".
> I think the comma is not showing maybe because of setting problem.
>
> I do not know how to fix this.
>
> In the Navsion database figures are correct.