Hello,
I am trying to generate a query with distinct counts. I have a list of plant names and I am trying to determine the number of occurrences for each plant species.
The first picture is a piece of my database with a list of plant species. As you can see there are multiples of the same plants in that list. What I am trying to do is count the amount of times that each plant occurs in the list. It should look like the picture below.
As you can see the list generated above is only returning a value of 1 for each plant species. I know that I have to do sub-queries, as Access does not support a direct DISTINCT function. Here is a picture of my SQL view to show what I have done, and probably where I have gone wrong.
Please let me know if you need anymore information.
Thank you in advance for any help.