Hi,
I need for my report a query as follows:
I have only 1 table A
I have many groups of 2 transactions each with the same Reference in the field Reference
I have 2 legs (transaction side) always so I know leg 1 has value 1 in the Leg field and Leg 2 is 2
In the leg 1 I miss one information that exists in leg2 (the date)
So I want to update groups of transactions based on References and get the date from 1 transaction = Leg1 and send it to the second transaction of leg2 based on those details.
Please provide the query it's quite urgent!
thank you so much