Hi, I am creating a query in Microsoft Access and cannot figure out how to implement store# into the query. I need two tables, a store# table of the 12 stores and the gross profit. My current query is:

SELECT Revenue - Cost of Goods Sold AS gross_profit

FROM Query1, Query3

WHERE

GROUP BY [store#]

What is the gross profit for each store in the 1st quarter? Save the new variable you create as "gross profit". Show Store\# and gross profit in the final output. Save this query as "Query 13". Hint: gross profit is revenue minus cost of goods sold. In this query, you need to utilize the results from Query 1 and Query 3