Only displaying 'unchecked' records?

[ChrisSedgwick]

Hi,

Pardon me for what I'm sure is a very simple answer but I appear to have just completely forgotten how to do this...

I want to run a query to show all my outstanding orders between two dates. I've done all this correctly and it works fine. However I only want the query to show me the records where the checkbox on 'tblOrders' is unchecked. For obvious reasons, I don't need to see these records, just that records that have been checked, therefore are outstanding.

I know there's an expression I need, but I'm not too sure what it is?

Thanks
Chris.

 

[pbaldy]

There seems to be a contradiction between the title and your description, but in query design view, try

True

If the title is correct:

False

 

[ChrisSedgwick]

So simple, thank you!

 

[pbaldy]

Happy to help!

 

[ChrisSedgwick]

Hi,

Hopefully you can help me out again, it' regarding the query I created in my above posts.

The query works fine up until I enter new data to the table. Now when I run the report which uses the query to return the data, it doesn't include the new data.

What could be the cause?

Regards,

 

[pbaldy]

Make sure that field is either true or false, not null. I'd give it a default value of false in the table and not let it be null.