title: Access: Expression too complex to be evaluated
body: <p>I'm trying to sort out values from a database by the weekending date. The script I'm using functions on 6 of my 7 databases (they are all constructed identically). The 7th database doesn't function. I get the expression too complex error. any help figuring out why??</p>
  
  <p>Here is my code:</p>
  
  <pre><code> SELECT UPC_Test.Type, 
          UPC_Test.[Model No], 
          UPC_Test.[Model Desc], 
          UPC_Test.[Serial No], 
          Format(DateValue([UPC_Test].[Test Date]+7-Weekday([UPC_Test].[Test Date],0)),"m/d/yyyy") AS [Test Date], 
          UPC_Test.Parameter, 
          UPC_Test.[Failure Symptom], 
          UPC_Test.[Repair Action], 
          UPC_Test.[Factory Select], 
          UPC_Test.[Test Station]
  FROM UPC_Test
  GROUP BY UPC_Test.Type, 
           UPC_Test.[Model No], 
           UPC_Test.[Model Desc], 
           UPC_Test.[Serial No], 
           Format(DateValue([UPC_Test].[Test Date]+7-Weekday([UPC_Test].[Test Date],0)),"m/d/yyyy"), 
           UPC_Test.Parameter, 
           UPC_Test.[Failure Symptom], 
           UPC_Test.[Repair Action], 
           UPC_Test.[Factory Select], 
           UPC_Test.[Test Station]
  HAVING (((UPC_Test.Type)="Production") 
  AND ((Format(DateValue([UPC_Test].[Test Date]+7-Weekday([UPC_Test].[Test Date],0)),"m/d/yyyy"))=[Enter]) 
  AND ((UPC_Test.[Failure Symptom])&lt;&gt;"") 
  AND ((UPC_Test.[Repair Action])&lt;&gt;"") 
  AND ((UPC_Test.[Test Station])="UPC RF Test"))
  ORDER BY Format(DateValue([UPC_Test].[Test Date]+7-Weekday([UPC_Test].[Test Date],0)),"m/d/yyyy");
  </code></pre>