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

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?

 

 

 

 

 

Outcomes