need a way to display data if checked

[Jery J.]

I am attempting to do a mail merge within a access report, i have 13 fileds
which are yes/no. I would like to setup the report to display only those
fields that have no as there value on the report so that we may send of the
mail merge to the recipient notifying them of documents they have not
submitted. What would be the best way to do this?

Example:

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Form 1 (Would be displayed if value is no)
Form 2 (Would be displayed if value is no)
Form 3 (Would be displayed if value is no)

Question#2 How can i get the report to print only the current record without
having to manually set it in the print properties screen everytime.

 

[Duane Hookom]

It might help if you provided your table structure (field names). It sounds
like your table might be quite un-normalized which would suggest normalizing
your data first.

Regarding your second question, see
http://www.mvps.org/access/reports/rpt0002.htm.