Query linked to a check box?

[Cyborg]

I am trying to run a query linked to a check box. Essentially I need the
query to return an answer based on a check box being ticked or not.

Basically it's a true or false query based on whether a field has been
completed on the table. The tick box on the reporting form should be ticked
if you want to exclude any thing which has a value in the table (e.g. it's a
date completed field - the report needs to show only items which do not have
an completed date).

I'm not very good at queries and think it needs an 'is null' part and a is
false/true part, but cant quite get my head around linking them all up

 

[Fred]

I noticed that nobody answered.

Not sure what you mean by "reporting form" Access has reports and forms,
two different items

Not sure what you mean by check box. But either way it should end up as
data in a field. (I.E. if on a form, the "box" on the form is just a way to
view or enter data into a field in the table.

Fine points will vary with the field type you choose, but regardless it
becomes just another condition on a field in a table in your query.

 

[John W. Vinson]

I am trying to run a query linked to a check box. Essentially I need the
query to return an answer based on a check box being ticked or not.

Basically it's a true or false query based on whether a field has been
completed on the table. The tick box on the reporting form should be ticked
if you want to exclude any thing which has a value in the table (e.g. it's a
date completed field - the report needs to show only items which do not have
an completed date).

I'm not very good at queries and think it needs an 'is null' part and a is
false/true part, but cant quite get my head around linking them all up

A Yes/No datatype field in a table can be displayed on a form using a checkbox
(as well as a combo box or a textbox); in any case, Yes is stored as -1 and No
as 0. If you want a query to select only those records where the box is
checked use a criterion of either -1 or True (they're the same thing).

If the checkbox is just on the form, not in the table, you've got another
problem and you'll need to explain in more detail.