Query..not return double?? Tables - Oracle (1 Viewer)

[_Brian_]

Ok. I have tables vinculate to ORACLE, the primary key of Oracle is double, from Access of query return one number rounding 1,00000902026541907589E+20 this is the problem, in query i have this funtion:
IIF(isnull([CAMPO1]);[CAMPO2];[CAMPO1]) this return one number ok field(CAMPO1) and other bad(CAMPO2 it's rounding). I need that return this query two doubles. example:

bad - 1,00000902026542E+20 = 100000902026542000000
ok - 1,00000902026541907589E+20 = 100000902026541907589

help me...

My english is bad bad bad...

 

[Dennisk]

You could try explicity converting the numbers to a double in your query
the function is CDble(Expression) or perhaps you could try converting to a string CStr(Expression)