Group/Count Combinations in Access Table based on Two Feilds
I have two columns in an Access table that I would like to group distinctcombinations for.
Field 1Field 2345TV345Press345Cinema347TV400Facebook457Cinema644TV644Radio899Facebook999TV
So for example below I would like to count field2 by the number of unique instances in column one. For example I would like to know how many instances are there of just TV in relation to field1 which equals 2 (Only 347 and 999 have TV only). Similarly instances of Facebook equal two. Instances of TV and Radio equals 1 (644)
So the final results would be something like this:
CombinationCountTV Only2Cinema Only1Facebook Only2TV, Press & Cinema1TV and Radio1 Is there an easy way to do this in Access either using the front end/queries or through using VBA or SQL?