AnsweredAssumed Answered

Report Based on Checkboxes

Question asked by DominickReda on Apr 16, 2012
Latest reply on Apr 16, 2012 by philmodjunk

Title

Report Based on Checkboxes

Post

Afternoon everyone,

 

I'm hoping this is fairly simple:

 

I have a table with multiple fields - the ones in question today are (1) "Name" [text field limited a value list of 4 constant choices] and (2) "Type" [Checkboxes - a total of roughly 50 choices - some records may have multiple selections]

I want to do a report as follows:

Lets say we have Joe, Joe and Jane for the names and red, blue, green and white as checkbox choices. There are 5 records so far as follows:

Joe - red, white

Jane - green

Joe - red

John - blue, green

Jane - white

 

I want to make a report that groups by each name and shows a total count of each checked choice for each person. So based on the info above the report would yield:

Jane

Red - 0

Blue - 0

Green - 1 

White - 1

--------------

John

Red - 0

Blue - 1

Green - 1 

White - 0

--------------

Joe

Red - 2

Blue - 0

Green - 0

White - 1

--------------

As always, thanks in advance for the help!

Best,

Dominick Laughing

Outcomes