AnsweredAssumed Answered

Report record exclusion needed

Question asked by synergy46 on Mar 21, 2009
Latest reply on Mar 21, 2009 by comment_1

Title

Report record exclusion needed

Post

I have 2 tables:

 

Members:

   MemberID.pk

   MemberName

   Status (text) -- Holds values like: "Deceased" "Active" etc...

 

Proficiencies:

   MemberID.fk

   Proficiency:  -- holds values like:  "programming" "accounting"  etc.

 

I have created a sub summary report grouped and sorted on Proficiency.  It works.  But it also includes members who have a status of "Deceased". (not desired)

 

Do I need to first perform a 'find' on a subset of the data where Members::Status <> "Deceased".... ???

 

Your thoughts are appreciated.

 

 

Outcomes