Check Box Values in Queries

[Rubz]

I have a database setup holding various comments about resources along with details of who sent them in, date etc. There are then a number of check boxes to show what resource(s) the comments refer to; book1, book2 etc.



I'm trying to put a query together to run off a report for whatever criteria the user wants, ie between certain dates, comments on book1. To do this I have created an unbound form [ReportForm] with the same check boxes as the main form and text boxes for start date and end date. In the query under criteria for each field I have added: =[Forms]![ReportForm]![book1] (or the equivalent for each check box). However when running the query it always shows as no records whether the [book1] checkbox on [ReportForm] is ticked or not.

I've tried this using just the dates (>[Forms]![ReportForm]![Start]) which works fine, and also using a text box in [ReportForm] for [book1] and adding "0" or "-1" which also works fine. This shows that it is picking up the text box data from [ReportForm] OK, but for some reason isn't recognising the True/False data from the check box.

Any thoughts on why this is happening / what I can do to make it work gratefully received. Thanks.

[maximus]

check the criteria that you have put for the Yes/No Fields. by Default CheckBoxes when unbound are named Check0, Check2. Have you typed the right name. Check it

[Rubz]

Doh. Was pretty sure I'd done that and checked it, but checking back again I hadn't. Thanks.

[maximus]

if your problem is solved mark the thread solved.