Extracting records from a memo form

[DeborahP]

I need some help. I created a database to capture information from an employee survey. Most of the answers required a check if they agree or no check if they do not agree. There was one "memo" field inwhich we allow the employee to VENT. I have provided the team with all sorts of reports with percentages and figures. Now they want to remove any comment that had money, pay raise, bonus etc. They also want to organize the comments in some type of flow. Like all the "pats on the back" in one area, Day offs in another, plaque on wall grouped together, etc.

Can one of you experts, please give me some help?

Thanks!

 

[grnzbra]

I would create a table with a key consisting of both the survey number and the question code, and a Yes/No field. I would make the memo categories as if they were just more questions.

When you run a crosstab against this, you can get a count of responses and if there are two memo categories that are someone entering data considered different but is determined to be the same, it will show up easily