Calculating totals and % change

[Angie]

I have a table with columns for county, age group, zip, and population data
for three different years. Can I create a query to calculate a % change in
population, or does this have to be done in Excel. I would also like run a
query to compare % change for the 65+ age group across the 5 counties. I
know how to select for the 65+ age group, but can't figure out how to add the
population totals for each individual county, and then calculate the %
change. Is this possible to do in an access query?

Thank you!

Angie

 

[Bob Miller]

Query with pertinent data for calculation of % change between 2000 an
2001:
SELECT Pops.County, Pops.Pop2000, Pops.Pop2001, Pops.Pop2002
([Pop2001]-[Pop2000])/[Pop2000] AS Chg1
FROM Pops;
You'll have to frormat the Chg1 field to percent.