Number field...how does one show decimal places ?


S

Steve

Hi,
I created a new field and chose Data type number. It is Field Size Long
Integer by default
I noticed in table view, having typed 3.05 into it, it became 3.
I have altered Decimal Places to 2, it had been Auto by default
that made no difference.
I have made Format generalNumber, it was blank by default,
still makes no difference.
still its rounding things up or down. 3.9 becomes 4 etc..
I need it to show decimal places in table view.

What am I doing wrong ?

I am unable to enter any data and make use of the display until I resolve
this !

Steve
 
Ad

Advertisements

K

Ken Snell \(MVP\)

A Long Integer data type is an integer data type -- meaning that it only
displays and stores whole numbers. Change the Field Size of that field to
Single or Double if you want to have decimal places in your numbers.

Note that Single and Double are floating-point numbers, so if you want
accurate decimals (no rounding or "floating"), then use the datatype of
Currency to get accurate decimals to 4 decimal places.

Decimal is another possible choice as the Field Size (Number datatype), but
it's behavior is described as buggy in pre-2007 versions. I'm not sure if it
behaves better in 2007 version, but you might want to try it.
 
Ad

Advertisements

S

Steve

Ken,
Silly me...Integer = whole number, forgot my school maths, many yrs ago.
Thanksfor the advice, now with Double and all's well.
Steve
 

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

Similar Threads

Access stripping decimal places in query 1
decimal place 1
Digits on right of Decimal points 1
constant decimal places 2
Allow 2 decimal places 2
DECIMAL NUMBER 6
decimal places 1
Decimals, rounding off 4

Top