Hi Tom
FileMaker 6.0
I'm sure I'm missing something simple here...
For a group I'm in, members ("Person 1", "Person 2", etc.) can
volunteer for areas of expertise. Some select several, some none.
I've got it set up with the "area" field being a value list where
they can check as many as they wish. (That way it's easy to add or
delete areas as appropriate>0
I want a report like this:
Area A (with it's name)
Person 1
Person 3
Person 4
Area B
Person 3
Area C
(none) (or, better yet, have "Area C" not even appear)
Area D
Person 1
Person 2
Hopefully the above is clear as to what I want. But I can't seem to
get it!
It's not an easy situation since the field you've to report on is a
multi-line field
See this tip file for a method of dealing with it, by Kevin Frank:
http://www.kevinfrank.com/download/counting-values.zip
Ciao
G. Pupita
Certified FileMaker 7 & 8 Developer
FSA Associate
