Filtering out rows based on values in other rows

[Remster]

Folks



I'm in a state of conceptual befuddlement over what I'm sure must be the simplest issue in the world.

In the query pictured in the attached image entitled 'DatasheetView', I want to filter out all rows where there's a DocumentID (first column) that has at least one tick against it under OriginatingOriginated (fifth column). So all occurrences of DocumentID 45 would be filtered out, as there's a tick against it in the first row in which it occurs, and all occurrences of DocumentID 47 would be kept in, as there are no ticks against it in any of the rows in which it occurs.

I've tried using DCOUNT in various ways, but only with the result of filtering out every row in whole datasheet. Help!

Remster

[NoellaG]

Hi,

create a query like : select distinct DocumentId where Originated = true.

Than link that query with an outer join and an 'Is Null' criterion or use it as a subquery to find out all records in query 1 without a related record in query 2

gr
NG

[Remster]

Thanks, that makes sense.