Percent format

  • Thread starter Anthony Viscomi
  • Start date
A

Anthony Viscomi

I have designated a field that resides within a table as:
Field Size = Long Integer
Data Type = Number
Format = Percent

When I enter -10% in the field; -1000.00 is displayed. What I am doing
wrong?

Thanks!
Anthony Viscomi
 
A

Allen Browne

Change the Field Size to:
Double

The integer types can only store whole numbers. Percents are fractions of
100, so an integer could only store 100%, 200%, and so on.

You still have to enter the % to get the -10% entry.
 
A

Anthony Viscomi

Thanks!
Allen Browne said:
Change the Field Size to:
Double

The integer types can only store whole numbers. Percents are fractions of
100, so an integer could only store 100%, 200%, and so on.

You still have to enter the % to get the -10% entry.
Click to expand...
 
Top