Only show 'yes' values in a report

M

Matt

I have created a table that displays a report with 'yes' or 'no' as a text
box. Can I get the report to return only the 'yes' entries and sort
accordingly?
 
J

Jackie L

Base your report off a query instead. You can put the Yes/No criteria in the
query and also create sort fields if needed. You need to do the actual
report sorting in the Sorting and Grouping property of the report. Let us
know if you need help with more specifics.
 
R

Rick B

Just filter the data source. If your report is based on a query, modify the
query to only include "yes" responses.

As far as "sorting accordingly" you did not tell us what you want to sort
on. Use the grouping and sorting option in your report to set the sorting.

Rick B
 
Top