eliminate records with checkmark in column

[Iris Shapiro]

This may be easy, I don't know, I'm a beginner in Access. I have a list of
inventory, some of which is inactive. These have a checkmark in a yes/no
column. I want to create a report of only the active items. What kind of
query [I think] would I have to create to do this?

 

[fredg]

This may be easy, I don't know, I'm a beginner in Access. I have a list of
inventory, some of which is inactive. These have a checkmark in a yes/no
column. I want to create a report of only the active items. What kind of
query [I think] would I have to create to do this?

But which are active? The checked or the unchecked records?
Include in the query all of the fields you wish to show in the report.
Include the [Check] field.

As criteria on this [Check] field, write:
-1
to return all the records that are checked.
or...
0
To return all the records that are unchecked.

 

[Iris Shapiro]

boy, that was easy! As you can see, I have a lot to learn. Thanks for your
help!

Iris Shapiro

This may be easy, I don't know, I'm a beginner in Access. I have a list of
inventory, some of which is inactive. These have a checkmark in a yes/no
column. I want to create a report of only the active items. What kind of
query [I think] would I have to create to do this?

But which are active? The checked or the unchecked records?
Include in the query all of the fields you wish to show in the report.
Include the [Check] field.

As criteria on this [Check] field, write:
-1
to return all the records that are checked.
or...
0
To return all the records that are unchecked.