Help with formating decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Al

What is the data type of the underlying field(s)?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top