Table Format

[RA]

I know I'm missing something simple, I can't get my table
to display a number in a decimal format. When I type
in .75 the table turns it into 1. OK, call me stupid,
what am I forgetting?

RA
..

 

[Cheryl Fischer]

Answered in: microsoft.public.access

 

[RA]

Neb=ver mind I found it, I used the double format

 

[Allen Browne]

Open the table in design view, and select the problem field.
In the lower pane, change the Field Size property to Double.

The integer types can only handle whole numbers.

 

[Guest]

You can set the filed's property to show however many
decimal places you want. When you select the number data
type, go to the general tab and Decimal places, and set to
what you need.

 

[Tim Ferguson]

You can set the filed's property to show however many
decimal places you want.

.... as long as you are using a floating point type of number and not an
integer....


Tim F

 

[Bas Cost Budde]

... as long as you are using a floating point type of number and not an
integer....

.... you can still *show* an enormous amount of decimal places. All zero.
Or, use some scaling trick. Seriously, in my checkbook application I
store all money amounts as integers. (Well, Longs, I am quite rich.) For
correct display I must divide by a humble 100.

It would even be possible to store the numbers as string, and perform
math with special objects. I've done that on analysis occasions. It is
*not* very fast.

 

[Tim Ferguson]

Or, use some scaling trick. Seriously, in my checkbook application I
store all money amounts as integers. (Well, Longs, I am quite rich.) For
correct display I must divide by a humble 100.

I'm disappointed: I assumed you would need at least 64-bits...

Tim F

 

[Bas Cost Budde]

I'm disappointed: I assumed you would need at least 64-bits...

Tim F

I said longS, now didn't I? <VBG>