AnsweredAssumed Answered

Multiple fields may contain same info.  How do I collate?

Question asked by sunspotsbonaire on Dec 31, 2009
Latest reply on Jan 3, 2010 by sunspotsbonaire

Title

Multiple fields may contain same info.  How do I collate?

Post

I have a database for an after-school program in which the kids can choose ten different activities from a list of about 50.  Any given activity could appear in any of the ten fields (choices 1-10).

 

I need to be able to collate all the fields at once to determine how many kids want each activity and also which kids want which activity but I have no idea how to do this.  I am a novice with relational databases and could use some help.

 

Thanks

 

Alan 

Outcomes