I have my data into my table. In the table I have CheckBoxes. Now I want to create two reports where in the first report are the names of the people that i haven't checked, and in the second the names of the people i have checked.

How is these possible... Thanx

Create a query with this in the CheckBox criteria:

No

And one with this in the Checkbox criteria:

Yes

Then create a report based on each query. Actually, create one report the way you want it, then copy and paste it, and then change the recordsource for the new one to the other query.

Alternatively, you can have the user select which one they want to see and pass the creiteria to one version of the report.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

I haven't work before so offen with Access. Can you please be more specifig about the Step's I have to make?

Have you created your report yet?

Use the query designer to create a query that shows all the people with checks. Add the check box to the query, and set it to Yes. Then save the query and copy and paste it and then in the copy, set the check box to No.

Then use the report wizard to create a report based on the query where the check box is set to Yes. Then copy and paste the report, open it, and change the record source to the query where the check box is set to No.

You will have two queries, and two reports - one for each query.

Then on the form, put two buttons, one for the Yes report, and one for the No report.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

I want Access to do it on it own. What i mean? At the beginning all my checkboxes are ''No''. Then i want to check (''Yes'') the one I want with the help of my Form. Then I need the two Reports (the One for Checked, the other for not Checked) to by updated. It's like making a grouping, the one who voted and the other who did not, sth like that if it helps. I sounds very dymanic but it is all I really need from Access to do for me.

you said ''Add the check box to the query, and set it to Yes''. What did you mean? I don't really know Query, please help me by saying the steps....

Thanx