Report to count field values
I am trying to use our database to do some reporting but am struggling to work out how to set this up.
Our database contains details of projects across the country and each project has a field for the Local Authority. This is selected from a set list of values to ensure consistency.
I would like to create a report which can show how many projects we have in each Local Authority - all it needs to show is the Local Authority names and a number. However, as the Local Authority field on each record is a text field (chosen from a pop up menu) I have no idea where to start with this. I can easily produce a report listing the projects by Local Authority, but I would like to know quantities.
Is it even possible?
Thanks in advance.