Hi,
I have a query with a calculated field that simply divides one field by another. The problem is the results are wrong with the decimal point being in the wrong place.
Eg the first record is 42/722 which should give 0.060941828254848. Instead I get 6.0941828254848.
The SQL is just FieldA/FieldB AS ABFactor.
Can anyone think what the issue might be?
Thanks