Counting similar responses from Multiple fields; output into a crosstab type view (1 Viewer)

chibearz

New member
Local time
Today, 17:17
Joined
Jan 26, 2012
Messages
1
Hi, I would like to take a table of data (example below with four rows of responses) as such:

Model ; SN; Date ; Windows; Tires; Interior
Ford; 1234; 1/1/2011; Good ; Good; Fair
Ford; 1234; 1/1/2012; Good ; Poor; Poor
Chevy;9000; 1/3/2012; Fair ; Good; Fair
Toyota;5555;1/3/2012; Good; Poor; Good

and turn it to a crosstab type output that groups the responses of conditions to resemble the following:

............Windows; Tires; Interior
Good; 3; 2 ; 1
Fair ; 1 ; 0 ; 2
Poor ; 0 ; 2 ; 1

Please HELP!
 
Last edited:

MStef

Registered User.
Local time
Today, 23:17
Joined
Oct 28, 2004
Messages
2,251
Look at "DemoWindowsTiresInteriorA2000.mdb" (attachment, zip).
I added "Table2".
Look at Tables, Query3, Module1.
Run Query3. I think it is what you need.
 

Attachments

  • DemoWindowsTiresInteriorA2000.zip
    12.3 KB · Views: 77

Users who are viewing this thread

Top Bottom