jmjbear1011
Registered User.
- Local time
- Yesterday, 22:42
- Joined
- Jun 17, 2012
- Messages
- 19
Here is the scenario:
Database (that I inherited), is for QA purposes.. Fields-> Employee Name, Score1, Score2, Score3, Score4, etc..
What I am needing to do is write a query, that gives a separate record for the employee where any of the scores are a "2". I could write a union query but there are like 20 fields that are scored.
Is a union query the only way or is there a better way? As a FYI, fields are not added or subtracted from the table. So they are always the same.
Suggestions?
Database (that I inherited), is for QA purposes.. Fields-> Employee Name, Score1, Score2, Score3, Score4, etc..
What I am needing to do is write a query, that gives a separate record for the employee where any of the scores are a "2". I could write a union query but there are like 20 fields that are scored.
Is a union query the only way or is there a better way? As a FYI, fields are not added or subtracted from the table. So they are always the same.
Suggestions?