I am trying to number each row (update the AmendmentNumber) in sequential order based off an ID (ContractID). Example below but also attached a screenshot.
I would like to Order By the Document Name as the Name has a combination of [Contract ID] & [DocumentID] in the beginning of the Name...