Query Question

[kylebellamy]

How do I query a count from a column where the inputs are one of 4 pits of text? What I need is like this:

The photo rights column has the terms "Unknown", "N/A", "Yes" and "No". I have at the start of the design view, a simple GroupBy statement for the 10 sections that have publishing in them. What I want is a column for each of the terms with the count for that term.

Section|Unknown|N/A|Yes|No|Total
_header|0 |2 |4 |0 |6

http://www.kb-design-studios.com

 

[jebry]

Hi!

If I am understanding your question correctly you need to use a cross-tab query.



Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[PHV]

Have a look at the IIf function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kylebellamy]

Ok, this may seem a little on the dumb side but what I did was to create a query for each of the options above and them place them as sub-reports on one main report. I know this is the wrong way (or rather, a not particularly efficient way but it was a start).

http://www.kb-design-studios.com