using percents

  • Thread starter Thread starter doug13
  • Start date Start date
D

doug13

Guest
I was having trouble getting the percent func to work, when I enter 5 or .05 into the box it comes up 500.00% or 0.00%. how do you get the percent function to work properly, and show 5%?
 
Doug -- I had a similar problem a while back and it relates to the data type setup for your table (not the form). If you set the field size to "single" (e.g., vs. Long Integer) it will fix the problem -- but not sure it there are better solutions.

HTH...

TGH
 
BTW I am using Acc2k -- I don't know if this fix will work in earlier versions.

I suggest for your future posts you include which version of Access you are using.

TGH
 

Users who are viewing this thread

Back
Top Bottom