Rennie

I am creating a membership directory from my FM membership database. I would like to get the names of the states to repeat at the top of the next column or page when the number of records for a particular state doesn't fit in only one column. I have two leading "sub-summaries when sorted on", the first for Country and the second for State. I will be printing in two columns per page. Thanks for any help in advance.

Thanks comment, that is simple and works perfectly!

Hi all, I am printing a directory from a membership list. No problem getting it laid out, sorted and grouped by country, state and last name but I want it to print like this: Country State Member 1 data Member 2 data etc…. and the problem I have is that the state field uses state abbreviations not full state names. I am trying to come up with a way to have the full state name display in the printed directory but still have the abbreviations in the address block of the data entry layout. Appreciate any creative ideas, Thanks!