edandcyn
04-14-2009, 12:42 PM
I have a table in access 2007. I would like a simple percentage to show in a column, and i can't figure it out. I would like column 3 to show the percentage of column 1 and 2. example 9/10=90%. I have gone blank on this one.
Uncle Gizmo
04-14-2009, 12:53 PM
You don't do this sort of thing in the table, you do it in query. If you need to store the values for some reason, ( not recommended) then use an update query to update the percentage column in your table.
However remember that if any of the values change, the result column will not change until you run the update query again. This is the main reason for not storing values, it's not necessary in most cases, and can lead to errors.