Extracting data from an Access table

DeborahP · 08-25-2006, 12:06 PM

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!

Chevy · 08-27-2006, 09:07 PM

Well, how many records are we talking? You could add a new field called "CommentType" and give it simple values like "Kudo", "Time Off", "Monetary", "Reward". Than manually set this filed for each record (if there aren't that many).

If you have a lot, you could try using Update Queries to set this field for you - something like if COMMENT is like "*money*" update COMMENTTYPE = "Monetary".

Two issues I see right off are the many ways of describing a montery reward, or any of the other categoris. Also, some comments might reference more than one type.

Thinking ahaead, you may want to alter (or suggest) the survey to include Yes/No fields and/or pick-lists for as much of the survey as possible. This will help organize future surveys.

08-25-2006, 12:06 PM	#1 (permalink)
DeborahP Registered User Join Date: May 2002 Location: South Carolina Posts: 29 OS: 2000	Extracting data from an Access table 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!

08-27-2006, 09:07 PM	#2 (permalink)
Chevy Retired Join Date: Jul 2003 Location: Notlob Posts: 5,452 OS: Vista Ultimate My System	Well, how many records are we talking? You could add a new field called "CommentType" and give it simple values like "Kudo", "Time Off", "Monetary", "Reward". Than manually set this filed for each record (if there aren't that many). If you have a lot, you could try using Update Queries to set this field for you - something like if COMMENT is like "money" update COMMENTTYPE = "Monetary". Two issues I see right off are the many ways of describing a montery reward, or any of the other categoris. Also, some comments might reference more than one type. Thinking ahaead, you may want to alter (or suggest) the survey to include Yes/No fields and/or pick-lists for as much of the survey as possible. This will help organize future surveys. Last edited by Chevy; 08-27-2006 at 09:09 PM.