printing a report based on checkboxes

[mstekkie]

i have a form that lists the employees of a company. if an employee will be tested, then the user clicks on the check box. what i want to do is to print a report that shows all the employees that will be tested.

i don't even know where to begin.

thank you in advance.

 

[Garridon]

What you want to do is create a query that the report will run off. The query will select whatever records you choose based on the criteria. Create a new query and add all the fields you'll need for your report. For the criteria for your checkbox, type in Yes to select the records that have been checked. When you view the query in Datasheet view, you should see only records with a checkbox that has been checked.

Now create the report--you can use the wizard to get you started--using the query as the basis for the report. All you need to do is make the report look the way you want; the query will select the records meeting the criteria.

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com