S
scadav
Folks,
I have a table that looks something like this:
UniqueID InspectionID InspectionType InspectionResult
1 10 Fire Extinguisher Passed
2 10 Flares Passed
3 10 Reflectors Passed
4 10 Jack Passed
5 11 Fire Extinguisher Passed
6 11 Flares Passed
7 11 Reflectors Passed
8 12 Fire Extinguisher Passed
9 12 Flares Failed
10 12 Reflectors Passed
11 12 Jack Passed
12 15 Fire Extinguisher Passed
13 15 Flares Failed
14 15 Jack Passed
I set it up like this so the users will have the flexibility to add
Inspection Types, without make new columns, etc.
The problem I am running into is that I want to create a query and would
like the results to look as follows (UniqueInspectionType values as column
headers):
ID FIRE EXTINGUISHER FLARES REFLECTORS JACK
10 Passed Passed Passed Passed
11 Passed Passed Passed NULL
12 Passed Failed Passed Passed
15 Passed Failed NULL Passed
Any suggestion as to how I get started with this query?
Thanks.
I have a table that looks something like this:
UniqueID InspectionID InspectionType InspectionResult
1 10 Fire Extinguisher Passed
2 10 Flares Passed
3 10 Reflectors Passed
4 10 Jack Passed
5 11 Fire Extinguisher Passed
6 11 Flares Passed
7 11 Reflectors Passed
8 12 Fire Extinguisher Passed
9 12 Flares Failed
10 12 Reflectors Passed
11 12 Jack Passed
12 15 Fire Extinguisher Passed
13 15 Flares Failed
14 15 Jack Passed
I set it up like this so the users will have the flexibility to add
Inspection Types, without make new columns, etc.
The problem I am running into is that I want to create a query and would
like the results to look as follows (UniqueInspectionType values as column
headers):
ID FIRE EXTINGUISHER FLARES REFLECTORS JACK
10 Passed Passed Passed Passed
11 Passed Passed Passed NULL
12 Passed Failed Passed Passed
15 Passed Failed NULL Passed
Any suggestion as to how I get started with this query?
Thanks.