Using percent for calculation

[smallWorld]

Ok, I have this field in my table called Discount (%). I set it to number field and in the format, I set it to percent.

When I enter 50, it automatically converts to 5000.00%. How can I display it as 50%?

In the report, I'll be using this field to calculate total.
E.g: Total = Orginal Cost * Discount. (380*50%).

I'll have 3 columns in the report, namely the Orginal cost, Discount & Total. It'll be displayed as 380, (190), 190. The result for discount will always be displayed in bracket to indicate substraction.

Thanks for the sample DB. I hope the above explaination maeks what I want clearer. Thx!

 

[Moniker]

This is fixed in Access 2007, but for every version of Access prior to that, percentages either need to be entered as decimals (50% = .5), or you need to put a little code in the AfterUpdate of the percent control on your form, as in:

Me.YourControlName = Me.YourControlName / 100

Stupid oversight? Yes, but not hard to work around. Again, Access 2007 does this automagically, so whatever way you take to work around this error, just know that it'll need to be removed upon conversion, if that happens. I could go into how to write your own Class and make your own percentage control, but that's overkill here.

 

[gemma-the-husky]

or just actually enter the % sign

eg enter 50% (sic)

 

[Bray1980]

I am very new to Access. I've only taken one college-level course on Microsoft Office, which included a section on Access. I must admit that this section was breezed over in my course.

I am in the process of replacing all of our spreadsheets with an Access database. That said, I'm having problems figuring out how to do calculations on our associates' productivity.

I've created a productivity table and userform. The associate will type the date, select the task at hand (which should automatically enter the goal per hour in the next corresponding field), enter the time it took to complete the task in the next field, and finally enter the quantity completed within the set time frame in the next corresponding field. I would like the Percentage and Average Per Hour (APH) to be automatically calculated after this information is entered.

To calculate the percent, the formula in Excel is =Qty/(GPH*Time)

To calculate the APH, the formula in Excel is =Qty/Time

Example:

Date | Task | GPH | Time | Qty | Percent | APH

Can anyone help me figure this out? Thank you in advance! Have a great day!