Count responses based on entires of other table

[VictoriaAlbert]

Hello hello -


I want to do a query that counts the responses in one table that match the values of another table. So, for example

Table Options
Blue
Green
Red

Table Responses
OrderNum Color
12 Blue
21 Blue
33 Red

So, I want a query that outputs:
Blue 2
Green 0
Red 1

Any insight would be much appreciated. So far I've only built queries using Query Wizard (so SQL code still reads like Greek to me).

Thanks.

[June7]

This is an aggregate (Totals) query. Build a SELECT query to retrieve the Color field twice then click the Totals button (Sigma symbol) on the ribbon. On the Total row under each Color field select GROUP BY for one and COUNT for the other. Access Help has more guidelines.

[VictoriaAlbert]

This was a good start. To get the query to work, though, I had to link the tables and change the link properties to show All the data from the Table with the options.