4 Replies Latest reply on Sep 2, 2009 2:29 PM by firth5

    Report Totals using a changing value list

    firth5

      Title

      Report Totals using a changing value list

      Post

      I'll start by saying what I want to do:

       

      I'm writing a database that will track drawings (aka DESIGNS), with various data about each design, including date assigned, date completed, the name of the artist, etc.

       

      The ARTIST field uses a value list derived from a different table, so that when the staff changes, the value list will change with it.

       

       

      I would like to generate a report that shows all of the Artists, and the number of designs they have on their plate.

       

      What is the best way to go about this?