"Number" data type problem

[MarkRCC]

Hi.

I have a field within a table (2 fields total: company name & rate) with the following settings:

field name: rate
data type: number
field size: long integer
format: percent
decimal places: 0
default value: 0
The default value in the field itself shows: 0%

When I attempt to populate the table, the following occurs:

company name: XYZ Company
rate: 100%

When I hit <tab> to go to the next record (I'm in datasheet view to populate the table), the value in the rate field changes to 10000% (adds 2 additional zeroes to whatever value I enter).

Any ideas why this might be happening? I'm sure it's a setting I'm missing or have wrong, but I can't find it.

Many TIAs!

Mark

 

[Golom]

The effect of percent formatting is to multiple the entered value by 100 and append a &quot;%&quot; sign. It's intended use is to be able to present things like 0.75 as 75%. You have defined this thing as a long which means that it can accept only whole numbers. You need a Single, Double or Currency data type so that fractions can be entered.

 

[MarkRCC]

Thanks Golom.

I just realized my mistake. I appreciate the FAST response!

Mark