format number

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

Guest

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
 
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.
 

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

simple formatting 18
formatting a number in a text box 1
Formatting decimal place with form name etc. 2
round up to the next 1/2 kg....formatting 2
Formatting a decimal 1
decimal point in general number 1
Problem entering numbers 3
Decimal number with ListCount in the expression 4

Back
Top