Counting Mutiple Text Fields

[Guest]

I have a report that I need to do that caluculates the number of entries
that meet a certain criteria within a group.

I have a field called [Heard About] that is a text field that has a row
source of a value list with the following Items.
"RENO GAZETTE JOURNAL";
"SPARKS TRIBUNE";
"RENO NEWS AND REVIEW";
"POSTED ELSEWHERE";
"WORD OF MOUTH";
"ONLINE";
"OTHER"

I have a reoprt that groups this "heard about" data by "Recruitment ID" (a
text field that simulates a "mm-yyyy" datatype - and "Position" another text
field that lists the various positions.

I need a report that counts all the records for each response option in
[Heard About] -
How many people said RENO GAZZETE JOURNAL
How many people said ONLINE ... etc ...

then group those counts / percentages by Recutiment ID and Position

How can this be done - I am new to reports and find them somewhat confusing.

thank you ,

Steve

 

[John Milward]

Steve

If you place a text box in the detail section (Call it txtTotal) and set its
data source to be =+1
and then set running sum to be "Over Group" this will count the records in
each
(You can set visible = NO for this if you dont want to see the numbers)

In the section footer put another text box that has its data source set to
=[txtTotal]

Voila

Hope this helps

john

 

[Guest]

JOhn,

It worked somewhat like what i had envisioned but there seems to be huge
gaps in between text ..i am assuming that this is space reserved for the list
of each individual response. is there any way to get rid of all of this extra
space - functionally the report works but practically, it is misformated.
Also I have some people who didnt respond to the question and therefore have
a null value for the field ...what can I do to handle null valies in this
report.

thanx

Steve