I have a database now with different nationalities and their city of residences in the US. Now, I am tasked to calculate the percentage of Filipinos living in each city.
May I ask for advice on how to do it automatically on Access? Thank you!
Database Calculation Query
Novice
Windows Vista 
Access 2007
Database Calculation Query
I have a database now with different nationalities and their city of residences in the US. Now, I am tasked to calculate the percentage of Filipinos living in each city.
May I ask for advice on how to do it automatically on Access? Thank you!
I may not be right
Windows XP Access 2003
do a aggregative query, count for people, group by city, criteria: nationalities='fillipinos'
Novice
Windows Vista Access 2007
Thank you so much! Will try doing that!
calculation in a query
IIF() in a query calculation
Query Calculation
Posting Permissions
Reply With Quote