Simple query to show when items are not checked?

[mrwistles]

Afternoon all,

Having a total nightmare I run a tiny company and the only person with any access xp has just left.



I need a very simple query.

I have a database which has my three staff members and a list of their daily tasks. It then has a check box which they tick when they have completed it.

What I want is a query which will ask me for the date I want to look at and then show me all of the items which have not been set to "No".

I know this is incredibly easy but I am stuck.

Thanks for your help.

[mrwistles]

I can do the parameter query part which asks for the date.

I am just unsure of the syntax to use when asking it to return only items which are unchecked.

[weekend00]

can you get those items which are checked? please show us your query.

[mrwistles]

Hi weekend,

So I have a table with the fields Task 1-9 and the date. The users are to check the box once completed.

In the query I have every field with a parameter query - "[Please enter the date required]" in the date field. I am unsrure of the syntax to use to return only items which have not been checked.

[weekend00]

I don't know your field name for the checkbox, assume it's "checkfield",
then you can put "NO" in criteria of the field "CheckField" to get all the unchecked items

[mrwistles]

I don't know your field name for the checkbox, assume it's "checkfield",
then you can put "NO" in criteria of the field "CheckField" to get all the unchecked items

Thanks for the reply.

My field names are Task 1, Task 2 etc...

If I put "No" in the criteria in the query once run it returns all items as unchecked even though in the table only three are uncheked.

[weekend00]

I need to check the code in your query. better with fieldname and type of your table.

[mrwistles]

I need to check the code in your query. better with fieldname and type of your table.

I don't have any code. I created it using the wizard.

All I want to show is where field names 1-9 are unchecked for a specific date. I have entered "[Please enter the required date]" in the date field.

All of the field names have a data type of Yes/No apart from the date.

[mrwistles]

Sorry worked out how to get the code: -

SELECT tbl_Chris.[Task 1], tbl_Chris.[Task 2], tbl_Chris.[Task 3], tbl_Chris.[Task 4], tbl_Chris.[Task 5], tbl_Chris.[Task 6], tbl_Chris.[Task 7], tbl_Chris.[Task 8], tbl_Chris.[Task 9], tbl_Chris.Date
FROM tbl_Chris
WHERE (((tbl_Chris.[Task 1])=No) AND ((tbl_Chris.[Task 2])=No) AND ((tbl_Chris.[Task 3])=No) AND ((tbl_Chris.[Task 4])=No) AND ((tbl_Chris.[Task 5])=No) AND ((tbl_Chris.[Task 6])=No) AND ((tbl_Chris.[Task 7])=No) AND ((tbl_Chris.[Task 8])=No) AND ((tbl_Chris.[Task 9])=No) AND ((tbl_Chris.Date)=[Please enter required date]));

[weekend00]

if you don't mind, please upload you database here, in .zip file.

[mrwistles]

I can't do that as my filewall will not let me. I will create an identical one when I get home and put it on here.

It only has 1 table with 9 fields (the 9 listed above). All of the fields are Yes/No

All I want is a query to show the items which are still set to no (unchecked)

Thanks a lot for your help it is really appreciated.

[weekend00]

Your query should return the items with all 9 fields are unchecked( not as you said all items), if any one field is checked, the item won't show in your query. is this what you expect?
or you want items with any one of 9 fields is unchecked?

Thanks for the reply.

My field names are Task 1, Task 2 etc...

If I put "No" in the criteria in the query once run it returns all items as unchecked even though in the table only three are uncheked.

[mrwistles]

Your query should return the items with all 9 fields are unchecked( not as you said all items), if any one field is checked, the item won't show in your query. is this what you expect?
or you want items with any one of 9 fields is unchecked?

So in the table for 02/09/10 all but three items are checked.

When I run the query it returns all items as unchecked.

[weekend00]

I could not find any problem with you query,

[mrwistles]

I will load the database up when I get home.

Thanks weekend.