create cursor MMRView (State C(2), ccode C(2), town C(4), County C(15), City C(20), ; Lender C(6), LndrName C(40), ; RankNumAll I, RankNumPur I, RankNumRef I, ; YTDNumAll I, YTDNumPur I, YTDNumRef I, ; YTDVolAll n(14,0), YTDVolPur n(14,0), YTDVolRef n(14,0), ; RankVolAll I, RankVolPur I, RankVolRef I, ; PTDNumAll I, PTDNumPur I, PTDNumRef I, ; PTDVolAll n(14,0), PTDVolPur n(14,0), PTDVolRef n(14,0), ; MksNumAll n(6,2), MksNumPur n(6,2), MksNumRef n(6,2), ; MksVolAll n(6,2), MksVolPur n(6,2), MksVolRef n(6,2) )So, I have different sets of ranking (by Number and by Volume, All (Sales+Mortgages), Pur (Purchase - Sales only), Ref (Refinance - Mortgages only)).