>That works in that it only brings back on record, but it brings back the lowest numbered ticket (first ticket created), where as I want it to return the highest numbered ticket (most recent ticket created).

I think it will return the max, if you order the view by ticket number in descending order.