not rounding percentages

G

Guest

i am running an update query to calculate a percentage and update a table.
The table keeps rounding the percentage to 100.00% when it should be 99.16%?
I have my table set to field size is decimal and format is percentage. Any
help would be great.
 
V

Van T. Dinh

Which data type you use for this Field in the Table Design?

You need Data Type "Number" and the Field Size needs to be Single, Double or
Decimal.

Note that Integer, Long can only store whole number and Access will round
the number before storing in these Fields. This is most likely what you
experienced.
 

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

Combo Box using a Percentage Field 3
Access Group by precinct, calculate percentage of older voters 0
rounding errors in access 1
Displaying records 1
Cumulative percentages 3
Report-Chart Wizard-AVG instead of SUM 2
Accumulated Percentage within a Pivot table....CAN ANYONE HELP?!?! 6
Percentage Data Type 4

Top