AnsweredAssumed Answered

Help with Calculations

Question asked by NathanApps on Aug 15, 2011
Latest reply on Aug 15, 2011 by philmodjunk


Help with Calculations


Hi Everyone,

I'm working with an existing databse that has staff names and room numbers. Simplified, it looks like this:

Name Room
John 1
Henry 2
Mary 1
Susan 3
Becky 4
Mark 5
Fred 1
Jamie 5

What I would like to do is to make a "room report" that lists all the rooms, how many people occupy each room and who the people are that occupy a particular room. 

Something like this:

Room Occupants Occupant Names
1 3 John, Mary, Fred
2 1 Henry
3 1 Susan
4 1 Becky
5 2 Mark, Jamie

Could someone point me in the right direction? I've had limited experience with Filemaker Pro but extensive experience with Excel. 

I've worked out how to add fileds that do calculations but am unsure where to go from here.

Thank you,