title: Access Query: too complex
body: <p>I am trying to run a query as part of a report to determine if an event needs to happen. There are lots of combinations because a subsequent event depends on the observations in the first and second event, and these combinations vary by fish size and are grouped by species. Hopefully that provides some context. I have scoured the questions on here, but haven't found any solutions to this exactly. Here is a snippet of the code. The code is about 160 lines or so, mostly of it contained within the Switch function.  Thank you for any thoughts!</p>
  
  <pre><code>SELECT headerid, species, ageclass, P1, P2, P3, P4, P5,
  switch(ageclass in ('Subyearling', 'Yearling') and P3 is null and P1&lt;4 and P2&lt;1,    
  'SHOCK',
  ageclass in ('Subyearling', 'Yearling') and P3 is null and P1 between 4 and 5 and 
  P2&lt;2, 'SHOCK',
  ageclass in ('Subyearling', 'Yearling') and P3 is null and P1 between 6 and 7 and   
  P2&lt;3, 'SHOCK',
  ageclass in ('Subyearling', 'Yearling') and P3 is null and P1 between 8 and 9 and 
  P2&lt;4, 'SHOCK',
  
     ageclass like 'Subadult' and P3 is null and P1&lt;5 and P2&lt;1, 'SHOCK',
     ageclass like 'Subadult' and P3 is null and P1 between 5 and 8 and P2&lt;2, 'SHOCK',
     ageclass like 'Subadult' and P3 is null and P1 between 9 and 11 and P2&lt;3, 'SHOCK',
     ageclass like 'Subadult' and P3 is null and P1 between 12 and 13 and P2&lt;4, 'SHOCK',
     ageclass like 'Subadult' and P3 is null and P1 between 14 and 16 and P2&lt;5, 'SHOCK'
  
     as Event from data;
  </code></pre>