Could I check with someone that when 2 load statements are coded as below that the NoConcatenate only needs to go above the first Load ?
Where RowNo > 3;
AutoNumber([Value],[Group1]) as RowNo
Order By [Group 1],[Value] desc;
You might not even need one because this table includes a new field called RowNo, but having it in there doesn't harm.
Retrieving data ...