How to do a count from field to field


#1

This is for an art market.

I have artists that sign up for one or more of 12 shows a year. I need a count of each artist’s “art medium” (painting, ceramics, jewelry etc) for each month.

The artists and months have their own tables. Any tips on creating fields in the Months table showing how many " art mediums of each there are?