Hi All,
I need to make an update query, but it seems it exceeds my knowledge.
I convert the task into a pseudo-table for explanation
The table (Customers) have the following fields:
ID, CustId, Amount, Correction.
There are fields, where the Correction-field has no value.
What I need to do is to find the highest Correction from the given CustId-s and add it to to the correction-field, if it is empty.
example
1;CompanyA;100;(null)
2;CompanyA;200;10;
3;CompanyA;300;20
record #1 should be populated with 20
Thank you