How do I set up a database in access without any rounding?

K

keken

I just want to know what I need to do so that when I enter numbers with
decimals it doesn't automaticly round
 
L

Lynn Trapp

Use the right datatype. The default type for numbers is long integer and
integers don't have a decimal value. Use Single or Double.
 
D

David420

You need to set the field size to 'double' (floating-point) or 'decimal'
(fixed-point). To do this, open your table in design view, select the field
you want to be able to accept decimal numbers. Look down, find the 'Field
Size' property. Change this to either Double or Decimal depending on whether
you want fixed-point or floating-point numbers.

A fixed-point number is useful for things like money, where you always know
how many decimal places you need.

A floating point number is useful for qoutients, money-market distributions,
and any other field where the number of decimal places is not known at
design-time.

Hope this helps.
 

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

Top