Analyze information..Access 2007

  • Thread starter Thread starter mm
  • Start date Start date
M

mm

I have a number of tables that share the same quesionaire, but with different
answers- those answers are grade only 3 ways with different colors.

How can I analyze and cross analyze the 3 different color answer from each
table?

Examples: a. I want to see how many "red's" I have from Project 1
b. I want to see how many "red's" I have in Project 1 vs Project 3, and if
possible what question each one is
 
There is a basic document we use that consists of over 100 questions we use
to assess our clients vulnerabilities to the questions we ask. There is
another column which represents our grade to them which is based on 3 answers
in which we use a color to represent our grade to them. All the tables have
the standard question column, but differing grades.
 
I would create a union query from the tables and base the analysis on that.
If you don't have a table identifier in the table you can do it in the query.

I think the following will just produce a column with 'table1' in every
record.

expr1: "table1"
 
Back
Top