M
mkuethe
I want to export a query from Access to Excel and then analyze the data
What I'm pulling into Excel is data with 31 columns. (30 are audi
questions and the last is the name of the person being audited.)
Row 1 is a header row, showing each question's description. (i.e
Greeting, time check, transfer, etc.) The remaining rows are either 1
0 or -1 for the 30 questions, and the person's name in the last column
("1" is considered a pass, "0" is considered a fail, and "-1" i
considered not applicable.)
The purpose of the analysis is to identify all questions scored as "0
for each person.
The problem is, each person has more than one audit, so I guess I nee
some kind of lookup formula that will look at the scores for all o
each person's audits and return the question description for all case
of a "0" score.
For instance, John Doe scored a "0" on Greeting in three differen
audits, but only one "0" on Transfer. I would want the formula t
produce the following results:
John Doe:
Greeting
Transfer
Greeting
Greeting
We would then analyze the data each month, allowing us to identif
trends. (i.e. John Doe scores "0" on greeting several times eac
month - maybe additional training is needed for John on greetin
requirements.)
If anyone can assist, I would greatly appreciate it. If needed, I ca
provide further information
What I'm pulling into Excel is data with 31 columns. (30 are audi
questions and the last is the name of the person being audited.)
Row 1 is a header row, showing each question's description. (i.e
Greeting, time check, transfer, etc.) The remaining rows are either 1
0 or -1 for the 30 questions, and the person's name in the last column
("1" is considered a pass, "0" is considered a fail, and "-1" i
considered not applicable.)
The purpose of the analysis is to identify all questions scored as "0
for each person.
The problem is, each person has more than one audit, so I guess I nee
some kind of lookup formula that will look at the scores for all o
each person's audits and return the question description for all case
of a "0" score.
For instance, John Doe scored a "0" on Greeting in three differen
audits, but only one "0" on Transfer. I would want the formula t
produce the following results:
John Doe:
Greeting
Transfer
Greeting
Greeting
We would then analyze the data each month, allowing us to identif
trends. (i.e. John Doe scores "0" on greeting several times eac
month - maybe additional training is needed for John on greetin
requirements.)
If anyone can assist, I would greatly appreciate it. If needed, I ca
provide further information