How do I do percentages in access

J

Jennertfer

I am working with trying to get conversions. Example I need to get the
percentage of the number of tours divide by the number of leads. I can't
seem to know how to create an expression that will do that. It has been
saying that I have entered an invaild syntax.
 
D

Duane Hookom

Do you have anything else you would like to share with us? Some information
about your tables and data might be really valuable.
 
D

debra turner

make sure that you put the field name EXACTLY like it is in the database.
Here is an example of a division

=([Field name])/#(you are wanting to divide by)


it should work easily
 
M

Michael Gramelspacher

deturner91961 said:
make sure that you put the field name EXACTLY like it is in the database.
Here is an example of a division

=([Field name])/#(you are wanting to divide by)


it should work easily
Click to expand...
The method above will give you a number. 25/100 = .25 You could
multiply .25*100 = 25, with is a percentage. I think though that
normally is is better to just let Access represent .25 as a percent. If
this calculation is done in a query, you can right click in the column
heading in design mode and select properties and then select Percent
from the drop-down list. You can also edit the field's properties on a
form and select Percent for the Format property.

See form image here: http://www.psci.net/gramelsp/temp/percent.png

All the values are calculated in a query and the fields formated as
Percent. So, 0.06620209 is display as 7% on the form.
 
Top