MS Access Reports?

Question

I have an MS Access database containing details of all my friends, family, business contacts etc. On the form where I enter new contacts, I have a number of tick boxes which include the contact in certain categories, e.g. Xmas card list, childrens' party invitation list etc. I have created a report to print out mailing labels, sorting entries so that the category that I want is at the top, so, for instance, I can print off all the mailing labels for my Xmas cards, and these will be on the first few sheets of labels, but I still get a mailing label for everyone else in the database. Is it possible to get a report that only shows the contacts I want, rather than simply sorting those that I want to the top?

Answer 1

write a query which selects only the rows you want then base the report on that query