Decimal Contorl

[quasar900]

I have a table set up with a numeric field with 2 decimal places. When this table runs through a couple queries and comes out in a report - somehow the number is rounded. Where would the rounding occur - how can I stop it from happening?

 

[Simon_MT]

Are you performing any calculations on the fields before they hit the reports?

Simon

 

[quasar900]

nope

It is a very simple sorting/ sequence number. I started out numbering the list 1, 2, 3, 4.... but when there were some additions i just made sure the table had it defined as numberic with 2 decimal places and used 2.5 to insert between 2 and 3. But it rounds it up to 3 so I have 1, 2, 3, 3, 4... instead of 1, 2, 2.5, 3, 4

 

[pbaldy]

What is the data type and field size of the field in the table?

 

[Simon_MT]

It sounds like your field maybe an Integer. In that case change it to a Single.

 

[quasar900]

The data type is number. The field type WAS double (not integer) but I did try changing it to single and that did not solve the problem.