Calculation and summary problem

[Valdrin]

HI all,

I know this has to be possible, but I'm having trouble with it.

I have a single table for programing panels being held for a convention, and each recored is for a different panel.

To make it easy to add and delete speakers for the panels I use several fields (Panelist1, Panelist2, Panelist3, etc.) all attached to a value list of the possible guest speakers. These fields feed a calculation field so all of the people on the panel are listed in one place.

What I need to do is make a layout that will list the number of panels that each guest is doing, but it has me stumped.

I am attaching a test version of the database below.

Any and all help will be greatly appreciated.

ProgramingDBTest.fp5.zip

Edited February 9, 2006 by Guest