How do I do percentages in access

[Guest]

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.

 

[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.

 

[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

 

[Michael Gramelspacher]

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

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.