Simple Rounding Question

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

Guest

Can't remember how to keep numbers from rounding up in either table or form view. Know that there is a function but don't have documentation available that I can get do. Decimal place not working properly. Need to allow for at least 2 decimals without rounding problem.
 
Open the table in design view.

Select the problem field.

In the lower pane, change the Field Size property to Double.
The integer types can store whole numbers only.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

neuro said:
Can't remember how to keep numbers from rounding up in either table or
Click to expand...
form view. Know that there is a function but don't have documentation
available that I can get do. Decimal place not working properly. Need to
allow for at least 2 decimals without rounding problem.
 
Back
Top