Filter by Check box

[Tejanorey]

I have a database with two reports, 1 form, and 1 table. On the form I have a list of "input type" of information, I have two reports to show who is present and who is absent (same fields), I need to know how to put a checkbox on my form so that that record will filter into my absent report (not going to show up in my "present" report unless I unclick that same checkbox). Can someone help me on how to do this... Tejanorey

"Do not attack the First Marine Division. Leave the yellowlegs alone. Strike the American Army."
- Orders given to Communist troops in the Korean War; shortly afterward, the Marines were ordered to not wear their khaki leggings to keep the enemy from immediately fleeing

 

[EllieFant]

I am guessing you have a yes/no field (check box) where you check it if they absent. You will need to create a query for each report that you want to generate. Put all the fields in the query that you want in your report (make sure you also put the absent/present field in the query too - even if it doesn't show on your report).

For the absent/present field, put true (meaning the box was checked) in the criteria - this will be your absent report.

For the present report, the word false (meaning the box was not checked) will need to be in the criteria for your absent/present field.

I am sure there are better ways to do what you are wanting to do, but this is how I would go about it myself - but then again, I am not a pro - YET!

Hope this helps some.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net

 

[Tejanorey]

EllieFant,
I keep gettin a "null" value error message when i try to create a report from the query. I also get two different pop windows that read "compile error" when I try to do this. also the selection from the check box jumps over the all of the other records. I'm sorry that it seems alot. I'm just needing some help because I need this for the field.. Tejanorey

"Do not attack the First Marine Division. Leave the yellowlegs alone. Strike the American Army."
- Orders given to Communist troops in the Korean War; shortly afterward, the Marines were ordered to not wear their khaki leggings to keep the enemy from immediately fleeing

 

[EllieFant]

Tejanorey,

Did you get this worked out? If not, let me know and I will try to help you. Sorry I didn't reply back to you...my new job started on Feb 10th and got busy really quick.
Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net