C
~CB
Using MS Access 2003, I need to comepletely flatten (ideally) a dataset. For
every user, there can be 2-5 recs, each rec may or may not have values for 14
attributes.
So data that looks like this:
User_Login Rec_ID Quality_Id Quality_Description Quality_Rate
onisA04 260 1 Leadership ability 2
onisA04 260 2 Persistence and drive 1
onisA04 260 3 Ability to work with others 1
onisA04 260 4 Confidence 2
onisA04 260 5 Flexibility 2
onisA04 260 6 Professional maturity 1
onisA04 260 7 Poise 2
onisA04 260 8 Goal orientation 1
onisA04 260 9 Ability to complete projects & deadlines 2
onisA04 260 10 Analyze problems & formulate solutions 2
onisA04 260 11 Oral communication skills 3
onisA04 260 12 Written communication skills 2
onisA04 260 13 Interpersonal skills 2
onisA04 260 14 Overall rating of applicant 2
onisA04 261 01 Leadership ability 1
onisA04 261 02 Persistence and drive 1
onisA04 261 03 Ability to work with others 1
onisA04 261 04 Confidence 2
onisA04 261 05 Flexibility 2
onisA04 261 06 Professional maturity 1
onisA04 261 07 Poise 2
onisA04 261 08 Goal orientation 2
onisA04 261 09 Ability to complete projects & deadlines 2
onisA04 261 10 Analyze problems & formulate solutions 1
onisA04 261 11 Oral communication skills 2
onisA04 261 12 Written communication skills 2
onisA04 261 13 Interpersonal skills 1
onisA04 261 14 Overall rating of applicant 1
Ideally needs to look like this (the value in each colum Rec_ID_x_Quality_xx
would be Quality Rate)
User_Login Rec_ID_1_Quality_01,Rec_ID_1_Quality_02...14,
Rec_ID_2_Quality_01,Rec_ID_2_Quality_02...14... for 5 rec ids. - 70 rows.
Any query based attempt fails so far, though I suspect the solution is
easier in VB - but I don't know how to do that. For starters I'd be happy to
get the data from in a format where each rec_ids 14 responses were on one row.
Many thanks in advance for help/references - etc! If it matters, the data is
not actual and I know this is somewhat silly - but tell it to the boss...
~CB
every user, there can be 2-5 recs, each rec may or may not have values for 14
attributes.
So data that looks like this:
User_Login Rec_ID Quality_Id Quality_Description Quality_Rate
onisA04 260 1 Leadership ability 2
onisA04 260 2 Persistence and drive 1
onisA04 260 3 Ability to work with others 1
onisA04 260 4 Confidence 2
onisA04 260 5 Flexibility 2
onisA04 260 6 Professional maturity 1
onisA04 260 7 Poise 2
onisA04 260 8 Goal orientation 1
onisA04 260 9 Ability to complete projects & deadlines 2
onisA04 260 10 Analyze problems & formulate solutions 2
onisA04 260 11 Oral communication skills 3
onisA04 260 12 Written communication skills 2
onisA04 260 13 Interpersonal skills 2
onisA04 260 14 Overall rating of applicant 2
onisA04 261 01 Leadership ability 1
onisA04 261 02 Persistence and drive 1
onisA04 261 03 Ability to work with others 1
onisA04 261 04 Confidence 2
onisA04 261 05 Flexibility 2
onisA04 261 06 Professional maturity 1
onisA04 261 07 Poise 2
onisA04 261 08 Goal orientation 2
onisA04 261 09 Ability to complete projects & deadlines 2
onisA04 261 10 Analyze problems & formulate solutions 1
onisA04 261 11 Oral communication skills 2
onisA04 261 12 Written communication skills 2
onisA04 261 13 Interpersonal skills 1
onisA04 261 14 Overall rating of applicant 1
Ideally needs to look like this (the value in each colum Rec_ID_x_Quality_xx
would be Quality Rate)
User_Login Rec_ID_1_Quality_01,Rec_ID_1_Quality_02...14,
Rec_ID_2_Quality_01,Rec_ID_2_Quality_02...14... for 5 rec ids. - 70 rows.
Any query based attempt fails so far, though I suspect the solution is
easier in VB - but I don't know how to do that. For starters I'd be happy to
get the data from in a format where each rec_ids 14 responses were on one row.
Many thanks in advance for help/references - etc! If it matters, the data is
not actual and I know this is somewhat silly - but tell it to the boss...
~CB