I have a report based on a query where I formated the data on the qry and on
the report for one field to be (Fixed and with 1 decimal). However, what I am
getting on the repport is very strange. the odd numbers are showing with on
decimal but the even are not like the following example:
2.1
2.3
2.200000
2.400000
2.1
2.3
Any I dea why. Again I made sure the formating is enforced in the query and
the report. the query is showing the right format but not the report.
Al
Jeff Boyce - 11 Dec 2006 20:43 GMT
Al
What is the data type of the underlying field(s)?
Regards
Jeff Boyce
Microsoft Office/Access MVP
>I have a report based on a query where I formated the data on the qry and
>on
[quoted text clipped - 13 lines]
> the report. the query is showing the right format but not the report.
> Al