Greetings. I administer a membership database for a rod and gun club I belong to. In the contacts table I have several fields including member name, member id number, etc. In the same record there are check boxes for what they are interested in. i.e. Archery, Rifle, Fishing, etc.
What I'm looking to do is get a count of each of the interests. The outcome should be Count of Archery is 123, count of rifle is 321, count of fishing is 222.
I'm thinking a query may be best. That way I can take the data and generate a graph.
Thanks in advance, any help is appreciated.
Version is Access 2013. I'm not afraid to use vba either if that is the best way.