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
 

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

Similar Threads

Turning Decimal time into HH.MM.SS format 8
format/decimal places aggravation 4
Access stripping decimal places in query 1
Currency format with 2 decimals not showing on report 2
Decimal places in a calculated Text Box 9
How can I set decimal places in a calculated control on a rpt? 2
Limiting Decimal Places in Report 2
Erratic Report Field Format 6

Back
Top