Hey guys, I have a database that want to collect information from but only from certain places.

The database has a Run No (Runs 1 - 10 for example) and within each run number is a stand size (we install stands into stores). What we want to do is collect a summary of information based on this info. So we want to know how many stand size 1, 2, 3 and 4 there are in Run 1 and do the same for all the runs within the table.

Can anyone help me trying to figure this one out?