Oppsite of the 'True' Criteria

[alexc333]

If I want Access to include a specific field I use 'True', how what if I wanted to exclude a specific filed? What would I type in the criteria?



Thank you for any help I might get

[TheShabz]

What exactly are you trying to do? The opposite of 'True' is usually 'False'

[alexc333]

Hi, Thanks for the reply.

False isn't an option, so will explain what I'm trying to do.

I've created a Query in which I select some fields using 'True'. However, I have another field that contains details that I do not want in the Query. So how would I exclude the records in a certain field from my query.

I hope I've explained that correctly.

[TheShabz]

I'm still not sure what you mean by "select some fields using 'True'". If you are in the query wizard, uncheck the checkbox that says "show" and it will use it as a criteria instead of displaying it.

[alexc333]

Umm, I'm confused by your answer.

Maybe I'm over complicating things.

Can I add a criteria to a query that will exclude from the query? So, I have a list of people who I do not want to send out information to, the field is a tick-box, so how would I exclude these people from my query?

Cheers

[TheShabz]

My mistake I thought you were using the query editor. I assume this is on a form. How many people do you have to choose from? Also, are you open to using a multi-select listbox instead of a series of checkboxes?

[alexc333]

Shabz a 'multi-select listbox' sounds very useful, but its not something I've used so far. Would be more than happy to have a go at them. There are about 400 records in the fields, but only a few of them need excluding.

[TheShabz]

So you have 400 checkboxes on your form? How are you displaying this?

[alexc333]

Opps no, 400 records. I have about 25 checkboxes fields.

[TheShabz]

Sorry for so many questions, I just want to make sure we're on the same page.

You're saying checkbox fields. Are these fields in a table or checkbox controls on a form?

[alexc333]

Shab thank you for taking the time to ask

I'm using a Table.

[TheShabz]

The checkbox is a field in a table? That makes it even easier. Give me the:
1. table name
2. names of the fields you want extracted
3. the name of the field with the checkbox

[alexc333]

Cheers

Table name: Table1
Fields to Extract: on hold 'and' don't send
Field with checkbox (that I would want included, would be for example): Cancer

[TheShabz]

Oh. Just add a field to the table as yes/no datatype. You can then either manually check them or use a query to do so. Once you have it set you can query to exclude the checkboxes. So lets say we want to exclude people with Cancer.

SELECT [On Hold]
FROM Table1
WHERE Cancer = False

[alexc333]

Shabz that sounds excellant and I'm VERY grateful, but its bedtime so I will give it a go tommorow when I'm more with it