I have a table which has multiple flags set for various eventand can be true or false.

The table is constructed along the lines of


FieldName Record 1 Record 2 Record 3
Section Alpha Bravo Charlie
DocumentName Transcript137 Transcript145 Transcript189
RequiredForEventA True False False
RequiredForEventB False False False
RequiredForEventC False False False
RequiredForEventD False True False
RequiredForEventE False False False
RequiredForEventF False False False
RequiredForEventG False False False
RequiredForEventH False True False


Etc...


In the example above, I only want to pull out Record 3 as Section Charlie and Transcript 189 entries are all False.

I relaise this can be done by using a Union Query and adding records to the selection of the flag is false, and also using and IIF() function, the only problem being neither solution
is particularly elegant.

Has anyone found a simple way to check that all specified flags in the record are False?

Thanks

J


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.9 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

bezz wrote:
asking. And probably for most questions that will be asked as well

There should be one T/F field. The rest of the fields should describe what
is either true or false. Something like:

Section DocumentName Event Required
Alpha Transcript137 A True
Alpha Transcript137 B False
etc

Rule of thumb:
databases: narrow and long
spreadsheets: wide and short

If you cannot modify this table's design for some reason, then you have to
get the data into this format. I would use a union query (I think you
alluded to this) to create a saved query (a view) called
RequiredEventsFolded, like this:

SELECT Section DocumentName, "A" As Event,RequiredForEventA As Required
UNION ALL
SELECT Section DocumentName, "B" As Event,RequiredForEventB As Required
UNION ALL
....

Now, your question is easily answered by a grouping query:

Select Section, DocumentName
FROM RequiredEventsFolded
GROUP BY Section, DocumentName
HAVING MIN([Required]) = False