format number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hngo - 03 Aug 2005 08:56 GMT

Hi,

I has a field that has been set by addition from a number of fields. The
data has been set to general number with two decimals. My problem is that
the number is shown with two decimals but the number has been round i.e.
24.35 became 24.00
24.65 became 25.00.

How do I fix this?? Please help

many thanks

Reply to this Message

Allen Browne - 03 Aug 2005 09:35 GMT

Open the table in design view.
Select the problem field.
In the lower pane, change the Field Size to:
Double

The integer types can only store whole numbers, regardless of how you format
and display them.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I has a field that has been set by addition from a number of fields. The
> data has been set to general number with two decimals. My problem is that
[quoted text clipped - 5 lines]
>
> many thanks

Reply to this Message