NUMBERS IN A TABLE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chris morrison - 29 Apr 2004 17:18 GMT

I have some experience in using databases, but for the
life of me I cannot understand why Access makes you jump
thru so many hoops to do a simple procedure. All I want to
do is set up a number field in my table called rate. I
want to be able to type in 2.87 and have it stay (and
display) 2.87, not 2.0 or 2.00? How can I make this happen?

Reply to this Message

Cheryl Fischer - 29 Apr 2004 17:30 GMT

Chris,

There are a number of different types of numbers that can be used in an
Access (or other) database, and they are represented by choices in the
FieldSize property of the particular number field in your table. The
default FieldSize for Number data types is Long Integer, which does not
display decimals The most frequently used of these are (from Access Help):
Integer, Long Integer, Single and Double.

For your purposes, you probably will want to change the FieldSize property
of your number field to Single or Double. Also, there is a Currency data
type, which is used to store money values.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

> I have some experience in using databases, but for the
> life of me I cannot understand why Access makes you jump
> thru so many hoops to do a simple procedure. All I want to
> do is set up a number field in my table called rate. I
> want to be able to type in 2.87 and have it stay (and
> display) 2.87, not 2.0 or 2.00? How can I make this happen?

Reply to this Message

Marin Kostov - 29 Apr 2004 18:37 GMT

Open your table in design view. Click at your field, and then F6 - this will
switch the panes and you will able to change the Field properties.
Then change he Field size to Single, the format propery to General Number
and the Decimal Places to 2 or more.
If your file size was Long Integer (I thing that is the default value)
Access will round the number to be Integer - without decimal places.

Signature

Marin Kostov
Microsoft Office XP Master Instructor

Reply to this Message

BerHav - 29 Apr 2004 19:16 GMT

Hi

The default field type can be changed in Tools - Options - Tables/Queries, e.g. Double or Text

Bernd

Reply to this Message

poster - 29 Apr 2004 19:28 GMT

> Open your table in design view. Click at your field, and then F6 - this will
> switch the panes and you will able to change the Field properties.
> Then change he Field size to Single, the format propery to General Number
> and the Decimal Places to 2 or more.
> If your file size was Long Integer (I thing that is the default value)
> Access will round the number to be Integer - without decimal places.

Reply to this Message

Ingleby Kernaghan - 30 Apr 2004 21:02 GMT

I think it is something to do with which number format you
pick when you set up the field in the table. Open the
Table in Design mode, go to the field and check what
number format it is - there are several. I can't remember
exactly which one you need, so try different ones. I am
also not sure that you can do a similar thing in Forms. I
had the same problem a few years ago. Stick with Access -
it is brilliant!

Reply to this Message