Decimal Placings

  • Thread starter Thread starter Harvey
  • Start date Start date
H

Harvey

Can anyone help with this problem. I have a table in
which one of the records could be, say, 4.75, 10.5 and so
on, How do you format for these numbers? I seem to be
having problems when trying to do caclulations with these
numbers in forms & reports.

Thanks in Anticipation
Harvey
 
Not sure if I'm understanding, but format the field for Number and then set
the type for Single.
 
Sorry I'm not very clear, but this has been driving me
mad!! I'v just tried changing the properties as you
suggested, but instead of comming up with say the 4.75 I
put in, it round it up to 4.8 in the form. An example of
what I was trying to say is that I have have fabrication
Hour @ 160 and maching hours @ 2.5 = 162.5 * 3 (which is
the number of items) = 487.5, but it is comming up with
488. Hope it is a little clearer.
Thanks for your speedy reply
Regards Harvey
 
Post the actual expression that you use for calculating the value. Are you
setting it equal to a variable before displaying it on the form? Or are you
using the expression as the control source of the control?

Also, post the following properties of the control:
ControlSource
Format
DecimalPlaces
 
On both your Table and your form there is a property for
Decimal Places. How are those set?
 
Back
Top