I want to organize data from a survey of 8 schools with about 20 questions. I want 20 subsummaries, with each question's answers grouped together (i.e. question 1, 8 responses, question 2, 8 responses). The database is set up for one record for each school. Am I going to be able to do this in one database? I'm thinking I'll need to set up a second one. Hmmm.

Bevin

that's what i thought. thanks.

bevin

If a record in you database is REALLY one school, there will be eight records in the file. If the 20 answers are all buried in these eight records, it will be a little hard to sort the same records by 20 questions at the same time. I think what you need is at least two files, one in which a record is a school and another in which a record is a school/question. You can use three files, one for schools, one for questions, and a third as a join file in which a record is a school/question (answer). -bd