eliminate records with checkmark in column

  • Thread starter Thread starter Iris Shapiro
  • Start date Start date
I

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?
 
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?
Click to expand...

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.
 
boy, that was easy! As you can see, I have a lot to learn. Thanks for your
help!

Iris Shapiro

fredg said:
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?
Click to expand...

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.
Click to expand...
 
Back
Top