Access Query Sumif Or Count Ifs, Access 2010

[ennin1]

Hi I am very new to Access and need help trying to figure out a ratio of stores in my table for example there are 10 stores nationally for Walmart, 1 in a particular zipcode, I need to have the query return 10% for that zip code (1/10)... and then multiplied by sales data in a separate table.

There are some retailers that are in the file but there are no sales data for.. and in those instances should exclude them.. the name of the retailer should be on both files.. I appreciate the help in advance

[June7]

Calculating percentages easiest done on report. Use report Sorting & Grouping feature. Do Sum() calcs in group and report footers. Reference those textboxes to do percentage calcs in other textboxes.

Otherwise, do queries that calculate aggregate data then join those queries.