doug13
04-09-2001, 03:27 PM
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%?
|
View Full Version : using percents doug13 04-09-2001, 03:27 PM 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%? TGHockett 04-09-2001, 08:02 PM 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 TGHockett 04-09-2001, 08:03 PM 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 |