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

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

Guest

I just want to know what I need to do so that when I enter numbers with
decimals it doesn't automaticly round
 
Use the right datatype. The default type for numbers is long integer and
integers don't have a decimal value. Use Single or Double.
 
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.
 
Back
Top