Decimal places not appearing (97)

Topic

New Reply

I specified a number field size as a byte with 3 decimal places. When I type 6.574 the table rounds immediately to 7, what

Reply | Quote

Replies

See:
http://www.access-programmers.co.uk/ubb/Fo…TML/000902.html

Reply | Quote

Just to keep answers all in one place, the simple answer is that byte field size allows integers from 0-255. That’s why you got rounding.

To store any decimal places you need to use Single, Double, or Currency depending on your needs.

See the built-in help for more details.

Reply | Quote