divide the results of 2 queries in a new query

  • Thread starter Thread starter tim S
  • Start date Start date
T

tim S

I have one query that give me the number of "stores" in
each state.

I have another query that give me the number of "stores"
that are considered an "18" store.

How do I create a query that will tell me the percent of
stores that are "18" stores in each state, represented as
a percent.
 
Join the two queries together on the State field and then do the arithmetic

SELECT Q18.State, Q18.StoreCount/QAll.StoreCount as Ratio
FROM Q18 Inner Join QAll
 
Back
Top