G Guest May 6, 2005 #1 I have Access 2003 and in my tables I determined a percentage to a value but I do not know how to show that value in "Query" table?
I have Access 2003 and in my tables I determined a percentage to a value but I do not know how to show that value in "Query" table?
G Guest May 6, 2005 #2 in your query type something like this in the field Percent: [MyValue]/[MyPopulation], then right click on the column and select format percent from the properties window
in your query type something like this in the field Percent: [MyValue]/[MyPopulation], then right click on the column and select format percent from the properties window