Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 24th, 2008, 12:07 AM
Registered User
 
Join Date: Mar 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Checkbox - Report Question

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

 
Old March 24th, 2008, 08:24 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
 
Old March 24th, 2008, 02:22 PM
Registered User
 
Join Date: Mar 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old March 25th, 2008, 06:48 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
 
Old March 25th, 2009, 03:42 AM
Registered User
 
Join Date: Mar 2008
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
checkbox checked by default by html:checkbox sachin.tathod Struts 3 December 4th, 2006 03:41 PM
crystal report question itaimun SQL Language 0 November 26th, 2006 09:51 AM
question about crystal report hageer Beginning VB 6 0 July 16th, 2006 09:01 AM
Report generation question pankaj_daga Access 5 December 21st, 2003 06:23 AM
Parameter Report Question(s) dbkester Access VBA 0 September 5th, 2003 03:58 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.