Row always at the same position: is this possible?

Just fyi... I originally ran across this while looking for something else... and now however many hours later... hum - ended up being a solution I needed as the Footer Row is to far away on tables with only 20 rows....
 
 
This is thrown together, junk code :) ... but its what I just used and it works perfectly.
 
I also do not have any fields/cells at the moment in this specific data set I am working with - so I am just guessing at the sort Alpha-Numeric sort order (Negative number to Z??)
 
Will play around with that, or if someone would know what would be the first sort character to the last sort character - that would help ... (like !@#$%&*())_=) where do they fit in? (and why the heck did this thing just autolink that??)
 
 
Data is the name I always use for ReportControls
 
TotalRecord is just a record that I gave its own name so I could reference it easily - and of course is what it says it is - the totals.
 
sa/tag of the TotalRecord Item is 0 for AlphaNumeric or 1 for Numeric
 
 
 
 
Insert this row last - and then it will be on the bottom - obviously - no need to worry about its value or anything as as soon as its sorted the first time - that will be taken care of.
 
 
 
 
 
Private Sub Data_SortOrderChanged()
    Dim tmp As ReportColumn
    Dim sa As Boolean
    Dim Item As ReportRecordItem
    For Each tmp In Data.SortOrder
        Set Item = TotalRecord(tmp.Index)
        sa = CBool(Item.Tag)
        If tmp.SortAscending Then
            If sa Then
                Item.Value = 1E+72
            Else
                Item.Value = "ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ"
            End If
        Else
            Item.Value = -1E+72
            'If sa Then
            'Item.Value = -1E+72
            'Else
            '
            'Item.Value = {low AlphaNumeric)
            '
            'End If
        End If
    Next

    Data.Populate
End Sub
 
 

**** I also tried the sortpriority method - seems straight forward - but did not work in the way I tried it.

It also seems like a much simplier method - if it would work in a way that it sorted something assigned a 0 always on top of something assigned a 1, on down the line - actually would be very cool - but it did not seem to do that (and it actually sctewed up all the sorting when I assigned it)