Forum Discussion

sabeensp's avatar
sabeensp
Helper IV
7 years ago
Solved

Compare value between multiple records

Hello,   I'm struggling with the following logic.   In my table, I have DateTime, Customer_ID, CustomerName, QtyBought and so on.   I need to implement following logic. If Record # 2 of Same C...
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    Then all you should have to do is replace the blue text in the query above with ROW-ID instead of [Datetime]