C
Cheryl
I have this exact same challenge. It is driving me nuts,
I'm sure there is a very simple answer.
I do know that if you can't get the report to do it, you
can build another field in your query that says "yes:=iif
([field]="yes", 1, 0) then in your report your text box
would =sum[yes]. I would rather not go that route for my
report, so if you do get another answer, please post it.
need to get a count of which ones are "yes" and which ones
are "no". I can do this in a query, but can I do this in
a report. If I can not count the values in a report, then
can I take it from the query and enter it into the
report? How?
I'm sure there is a very simple answer.
I do know that if you can't get the report to do it, you
can build another field in your query that says "yes:=iif
([field]="yes", 1, 0) then in your report your text box
would =sum[yes]. I would rather not go that route for my
report, so if you do get another answer, please post it.
records in one field. It totals on the report. Now I
need to get a count of which ones are "yes" and which ones
are "no". I can do this in a query, but can I do this in
a report. If I can not count the values in a report, then
can I take it from the query and enter it into the
report? How?