Extracting TRUE values only

[kloun04]

I have query that pulls in multiple fields from one table. I am trying to pull ONLY those records that are TRUE, but the simple approach for using criteria True only pulls records for that field or only the records that are in all the fields whose criteria is set to True.



Examples of field names:
Delirium
Dementia
Depression

How do I get the query to pull only the records whose value is TRUE for each field: delirium OR dementia OR depression? As mentioned previously, if I set the criteria to True for all fields, only those records that have all three values set to True will be pulled in. I am a novice, so hopefully you can expain in easy terms.

[orange]

Your sql would be something along this pattern

Select ..required fields.. From YourTableNameHere
WHERE
Dimentia = True OR
Delirium = True OR
Depression = True

[rpeare]

In terms of the query designer if you put criteria on the same line, the query assumes you are looking for ALL of the values. So put your TRUE criteria on different rows within the criteria section. Just be aware that if you have other criteria that criteria needs to be repeated on each row or you will get unexpected results.

[kloun04]

Orange... that did the trick. Thank you.