Simple Rounding Question

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

Allen Browne

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.
 

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

Stop Rounding in Forms 2
Rounding Question 5
Form Combo incorrectly rounding 1
Stop Rounding Currency 2
Where/how to set rounding property for a Query field 7
Rounding problems continue 1
Rounding numbers 3
Preventing rounding numbers to nearest dollar 2

Top