Hi Tracy,

Warren Group gathers information about all sales and mortgages of properties in MA, CT, RI, NH. Then this information is sold to different customers in different formats. One of our products is Monthly Market Share Report (called MMR) and a variation of it called Custom Monthly Market Share report (CMR). I developed a Stats application to calculate such statistics.

Anyway, I completely agree with your idea of "legend". I will present statusbartext for each columnheader (do you think I should also have a label on the form? - interesting idea), but I also need headers' captions. I just spoke with one of the users (I use his help in such linguistic occasions), he suggested RNAll, RNPur, etc., e.g abbreviate Rank and Num words. I'm going to ask my manager's advice too. (I have other related questions).

>I didn't realize The Warren Group was also a lending corporation? Or is it stats on other lending corporations you are compiling? There are standard abbreviations for that field (someone may post them for you). Typically there is a manual available with the information-it's more or less industry-wide. I would love to help you, but I work in the insurance field and its abbreviations are tough enough!!!! :o) Anyway, what I was thinking is, if you use any abbreviations that are not industry-standard, then what about a label somewhere on the form that contains a legend?
>
>Tracy
>
>>Hi everybody,
>>
>>I have a table with the following fields
>>
>>

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)).
>>
>>Mks is an abbreviation for Market Share, and YTD - Year-To-Date, ;
>>PTD - Choosen Month Data (oops, forgot what does PT stand for)
>>
>>I want to display this information in the grid. Rank is a number (each lender is marked).
>>
>>I'm thinking about the caption in the Header for each field. So far I set it to be the field name, but I want shorter and better version. My lack of creativity and English language knowledge makes this little task to be a problem.
>>
>>May be you can come up with a good suggestions?
>>
>>Thanks a lot in advance.