Query same field from multiple records

  • Thread starter Thread starter Bruce Pyett
  • Start date Start date
B

Bruce Pyett

Hi All

I have a performance appraisal database that uses an on-
line form for submission. The person doing the PA clicks
on the appropriate button for each of the questions. The
answers are Agree, Disagree, N/A, Don't know and the
coresponding numbers are 1,2,3,4,. When they press the
submit button it stores the info. in a text file. I then
run a macro to populate the PA table. What I'm looking for
is a way to tabulate the responses in each field on each
record according to how many 1s, 2s, 3s, 4s, were put down
for each person the PA was done for. So if Person 1 had 5
PAs done on them, this query would check each field and
tell me that 3 people gave Person 1, 1s on question 1 and
2 people gave 3s on question 1 and so on through the
fields of each record that pertains to person 1.
I hope this is not too confusing. Any help would be
greatly appreciated! Thanks.
 
Sounds like a Crosstab to me. Use PersonID and QuestionID as Column
Headings, the Rating as the Row Heading, and Count(Rating) as the Value.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Do you write queries? Maybe I am over simplifing or dont understand but ...if your records are all in one table its as simple as a crosstab query. The wizard will help you write it... I track replacement orders,we catagorize them as cust requested-tech requested -or special circumstance. I also get the orders from several sources--the order itself is one record and the type and source are fields within. So I could run a crosstab querey on say January orders and tell it to group the orders by source and tell me how many of each were submitted. Sounds to me like that is what you want.
 
Back
Top