Help with formating decimals

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
 
J

Jeff Boyce

Al

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top