Re: Srvey query help needed
From: Gerald Stanley (gcstanley_at_dsl.pipex.com)
Date: 03/31/04
- Next message: Michel Walsh: "Re: select in the midle of a criteria with iif..."
- Previous message: Mark: "Srvey query help needed"
- In reply to: Mark: "Srvey query help needed"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 03:44:44 -0800
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
>-----Original Message-----
>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
>
>.
>
- Next message: Michel Walsh: "Re: select in the midle of a criteria with iif..."
- Previous message: Mark: "Srvey query help needed"
- In reply to: Mark: "Srvey query help needed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
