Percent format

  • Thread starter Thread starter Anthony Viscomi
  • Start date 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
 
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.
 
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...
 

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

Format a Percent 4
Percent problems 4
Field Formatted % Inputs -> 0.00% 2
Percents 1
Access Test if value is less than percent 0
Format a percent 7
Using %, Access 2003 and Access 2007 1
Formatting a percent field 1

Back
Top