Query results based on checked record.

[jtm013]

Hello everyone and thanks in advance for any and all assistance!

So here is the problem. I have a table which lists an approved group of people to make changes.
The way the database is set up now. We cannot remove out of date names (we have one person who retired in 1995 still on the list) from the table because it will mess up the data validation in place on past records which have those people's names on them.
My plan is to create a new source for the combo box that uses these names.
This source would be a query based off the Approved Group Table.


So here is what I did. I put a check box on the approved group table the field is labeled "Active"
If the person is active the box gets checked.
I now have a query which is supposed to only select the checked records...but I don't know how to tell the query to do that apparently.
Here is what I have now.

Field:	Employee Number	First Name	Last Name	Active
Table:	Tbl_Approved_Group	Tbl_Approved_Group	Tbl_Approved_Group	Tbl_Approved_Group
Sort:
Show:	Checked	Checked	Checked
Criteria:				"-1"
Or:

When I run this I get an error message which says, "Data type mismatch in criteria expression."

Any and all help is appreciated thank you!

[burrina]

What data type is Active? I use a Number as the Data Type and use 1 Or -1 as the Validation Rule with a Default of -1
1 is Yes,- 1 is No.

HTH

[jtm013]

Hello,

Active is a number field. I changed it so that the default vale is -1.
And Yes=1 No= -1, but the Query still comes back with "Data type mismatch in criteria expression."

[jtm013]

Nevermind...I figured it out. I had the -1 in quotes as soon I took away the quotes it works fine.
Thanks for your help!