Query to leave out records if certain one selected?

[ayupchap]

Hi all wondering if you could help me please, I have got a lot of help from this forum on a number of issues recently and hope you won't let me down with this one.



I have a number of records which make use of a drop-down menu, this all works fine but how do I make a query with all the data which I can ask it to not include one of the options in one of the dropdowns so it leaves out the entire record for that person who had that option?

For example lets say I need to export a list of students who are not well to send a text out to them. Unfortunately the list also contains sent home as an option in the same list and I don't want to text those people, how do I make a query that will miss out those records which have sent home as an option allowing an export of students who are listed as not well?

I would rather have a query that eliminates one option rather than select an option as more options might get added to the drop-down list at a later date.

Thanks for any help

[ItsMe]

Do you have a field that represents the status of the student? Is there a "Sent Home" status field and a "Not Well" status field?

[June7]

What is this combobox for? Is it for data entry to record (and is bound to field)? Or is it just for input of filter criteria (and is NOT bound to field)? What are the values selected by this combobox - 'sent home', 'back to class', etc?

Options for using inputs as filter criteria are:

1. parameterized query that refers to the controls on form
http://datapigtechnologies.com/flash...earchform.html
This query can be the RecordSource for a form or report
http://datapigtechnologies.com/flash...mtoreport.html
http://datapigtechnologies.com/flash...tomfilter.html

2. use VBA to construct filter criteria and apply to form or report

[ayupchap]

Oh great thanks for the links. I will check those out.

[ayupchap]

OK so I worked out a way of doing it by saying ="Something" or "something else" and just leaving out Not Well. Thanks for the help