Only show 'yes' values in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating a value for a new record 2
Yes/No Query? 1
Have a Report Image Show or Not 2
Access Table Yes / No Field Question 4
Option group in a report 4
2007 Report Toolbars 1
Date Range Query. Criteria based in a table. 4
Display '1' as 'Yes' in Report 4

Back
Top