I have been struggling with this one for the past week and I’m at my wits end. Please help!
I have a log table that I need to find all transactions where the transaction type is “Update Item” and the previous entry for the same serial number so that I can show what the item was update from and to. The table looks like this:
Trx_Log
--------------
Date
Trx_type
Serial_num
Condition
Owner
I think I need to use Top 2 in a sub-query somehow but I’m not sure of the proper syntax.
Any help you can offer will be appreciated.