John,
Did not read all of the thread(s) but it appears
This
QUOTE
Have you tried using the format() function in your query?
Here is an example to have the query show only one decimal place:
SELECT format( yourtable.yournumberfield, "#.#")
FROM yourtable;
was used ???
I do not even know what your original question was so............ anyway hope that helps you