Srvey query help needed

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a table called Proxy which looks like this:

Resolution2 Resolution3 Resolution4a
Resolution4b Resolution4c Resolution4d
FOR FOR AGAINST FOR FOR FOR
NONE NONE NONE NONE NONE NONE
FOR FOR FOR FOR FOR FOR
FOR FOR FOR AGAINST FOR AGAINST

I need to build a query that will show me total FOR,
AGAINST etc. under Resolution2. 3, 4a etc.

I can build a query for each Resolution which counts up
the total but I'm lost when combining the whole lot
together so that I can develope a form to show the results
 
If you were to change the design of this table to hold only
one resolution number and result on a row, then the query
you are after would be very simple e.g.

SELECT [resolution number], [resolution result], count(1)
FROM Proxy GROUP BY [resolution number], [resolution result]

Hope This Helps
Gerald Stanley MCSD
 
Back
Top