title: SQL (Access): Multiple values per "ID" - Store as TRUE unless any FALSE
body: <p>Good afternoon!
  I have recently come across an issue that I am hoping can be solved with your help. Our system is [sadly] ran on Access (2007). I have decent experience with SQL and elect to use this method for most of queries rather than the Design View. However, this is the issue I have come across recently:</p>
  
  <p>A table (with its own primary key of course) contains the ParticipantID and Records. This table may contain multiple records per person due to having events at various locations. With this information we track whether or not each record is within our system already due to the location falling under our large "umbrella" (Internal). To make it look simple, it looks something like this, ignoring the primary key as we only care about the participant ID.</p>
  
  <pre>
  ParticipantID     Internal
  1                 -1
  1                 -1
  2                 0
  3                 -1
  3                 -1
  3                 0
  4                 -1
  4                 0
  </pre>
  
  <p>I want to be able to say if ANY of the records of a participant are not Internal (eg. =0), then in this query's results, store it as 0.
  Hence, the results table would look something like:</p>
  
  <pre>
  ParticipantID     Internal
  1                 -1
  2                 0
  3                 0
  4                 0
  </pre>
  
  <p>Does this make sense? Thank you in advance! </p>