counting values in a field

K

Kevin11

You can call a query builder right in your report. Create
two expressions in two end columns. First,
YesCase: iif([yourfield]=True,1,0)
NoCase: iif([yourfield]=True,1,0)

Insert control boxes for the YesCase and NoCase
expressions in your report detail. They don't need to be
visible. Insert the Count expressions in your report
Summary. That should do the trick. Good luck.

Kevin11
-----Original Message-----
Hello
Ok, so I have a report that I have counted the number of
Click to expand...
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?
 
Top