AnsweredAssumed Answered

Create a report that groups on a field with multiple values/record

Question asked by AngieH on Dec 2, 2015

I have a contact database that I have added a field called preserve.  It is a text field that allows multiple values by check-box from a value list.  We give access permits to some of our contacts to our natural areas.   I want to be able to print a report that lists all contacts who have access permits for each preserve.  I created a report that has a leading summary, and groups by preserve.  But it appears that only the first value in the preserve field for each record is showing up on the report.  I need all values in this field to be evaluated.  So if Mr. X has access to areas 1,2, and 3; Mr Y has access to areas 2, 3 , and 4; and Mrs. Z has access to areas 1, 3, and 5; I need a report to list each area (1-5) and each visitor allowed in that area (X & Z for area 1, X& Y for area 2; X, Y, & Z for area 3; etc.)  any ideas on how I can achieve this?