Hi,
I have a database with addresses of fastfood restaurants throughout California, broken down by county. I am trying to create a report to list the different fastfood restaurants in the state and include a count for how many counties have at least one of those restaurants. For example, there may be 50 El Pollo Loco's in California, but I want to know how many counties have at least one of them. So an example of what it would look like is as follows:
Del Taco: 48 counties
McDonald's: 58 counties
El Pollo Loco: 23 counties
etc.
I'm fairly green when it comes to this stuff, and I have scoured the internet for the answer to no avail. I have found methods to do counts of unique records which when applied, I can pull the number of counties in California or the number of different types of fastfood restaurants from my database, but I have yet to find something that allows me to get unique counts from a list that is being populated in the report (list of restaurants).
Any help would be much appreciated!