1 Reply Latest reply on Apr 5, 2013 1:25 PM by philmodjunk

    Report to count field values

    JessicaCol

      Title

      Report to count field values

      Post

           Hi

           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.