Report problems!

J

Janet

Hi!
I am trying to create a report that only shows records
that have a 'Yes' value in a particular field. I currently
have a report set up that sorts the records by the Yes/No
entry, but I would like one to only show the Yes. I'm new
with creating more advanced reports so ANY help will be
very much appreciated.
 
F

Fredg

Janet,
Make a query to filter the records first.
Include all the fields you want to show in the report.
In that Yes/No field's criteria line, write:
True

Then change the record source of the report to the query and you've solved
your problem.
 

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

Top