Also, in this same form, there is a field called "Capacity" that is the total capacity for the building, split into "Capacity_Male" and "Capacity_Female". Unfortunately (again), the client neglected to specify, and we are getting some numbers (Male+Female=Capacity) and some percentages (86% Male + 14% Female = 405 total)...

What would speed things up for our date entry people is to have a button that would say "percentage" and when pressed, automatically return a real number (a percentage of the total capacity, but in real number form) in the field and in the table. An alternative would be to just report on the form what the numbers are, and manually enter them to the table.

I've got the math down, I think:

[Capacity_Male]=[Capacity]*([Capacity_Male]*.01]

But how do I build this into an expression that will work OnClick???

Can you tell I'm new to this?

Cheers