Access 97 - Numbers

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

Guest

I am setting up a database and in the table i am recording acres and hectares
- some of these are whole figures some include decimal places - what type of
number do i pick to show a whole figure but also a figure with decimal
places? i.e. 150 or 15.25? I need my table to allow me to input both
figures??

In anticipation, thank for your assistance in this matter.
 
TORY said:
I am setting up a database and in the table i am recording acres and
hectares - some of these are whole figures some include decimal
places - what type of number do i pick to show a whole figure but
also a figure with decimal places? i.e. 150 or 15.25? I need my
table to allow me to input both figures??

In anticipation, thank for your assistance in this matter.
Click to expand...

Number with a Field Size of either Single or Double.
(these are both imprecise types)

Or use Currency (precise type with four decimal places).

You can use the format property to suppress the default dollar sign when using
currency (my preference).
 
Back
Top