query involving a yes/no box. Do I need a subquery?

[Linty Fresh]

I have a department which has activities assigned. Most of the activities are predetermined, but I have a textbox marked "other" where activities not covered in the predefined list can be entered. Along with this, I have a yes/no box (IsOther), which the user can check to enable this textbox.

I want a query which will return the regular activities along with the other activity only if the IsOther yes/no box is checked. I'm trying to make a subquery, but it's not happening. Any ideas? Thanks, guys!

 

[dcx693]

How exactly do you want the results displayed?

If you just created a query with activity and other activity fields, wouldn't the other activity field just be blank if there were no entry?

Can you provide an example of how you want the query result to look?

 

[damiendad]

I use the yes/no box a lot. If I'm looking for results based on if a box is checked, I create a query and under criteria of the yes/no field type in Like True. The yes/no function stores the data as yes=true, and no=false. I hope this helps.

 

[dcx693]

FYI: In your query, you don't need to type in Like True if you want True results, you can just type in True.

Are you saying that you only want the regular activities to show up if they have a corresponding other activity?

Sorry, I'm a bit confused.