title: return all records where the completed date is greater than a previous record's next due date?
body: <p>Ok, so this feels like a complicated query due to a poor design of the database, but alas -- it is there and in need of solving. The table has 5 fields: id(PK), itemNumber(FK), completedDate, completedBy(FK), nextDue.</p>
  
  <p>In the application, when someone records a task as being done, it fills in the completedDate, calculates the next due date and puts that in nextDue.</p>
  
  <p>What I need, is a query that will basically look at a record's nextDue date, then look ahead to the next record that has the same itemNumber, and compare with that completedDate; then return the row if the completedDate exceeds the completedBy date. Does that make sense? Can this be done? It sounds like it would have to be done procedurally vs. pure sql. TIA</p>
  
  <p>UDPATE:
  I guess I should be more specific. I need to use this query in a report, so if it needs to be done in VBA, I'm not sure how to get the results into that.</p>
  
  <p><img src="https://i.stack.imgur.com/0q0nD.png" alt="enter image description here"></p>