AnsweredAssumed Answered

Report Totals using a changing value list

Question asked by firth5 on Sep 2, 2009
Latest reply on Sep 2, 2009 by firth5


Report Totals using a changing value list


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?