Report Format

>> >> Good old-fashioned programming is your only solution. >> >You should check into the GROUP options of ace and 4gl REPORT functions. >Might save yourself some code. > >cheers >j. I should never say only... only say never. You're right the BEFORE GROUP OF statment along with the sometimes unknown semicolon will work. BEFORE GROUP OF person_id PRINT COLUMN 1 person_id; The newline will be supressed so that the next PRINT will be on the same line. It's been some time but I seem to remember not liking GROUP BYs. It was too slow or something, at least using aggregates like SUM was. I do know that if you had a lot of NULL person_id records that they'd all be grouped separately (shouldn't be an issue here though). || ======= **** **T* ======= ||John Regep || **** **** ||Store Systems Developement || **** *R** ||Kmart Corporation || =========== ********* =========== ||3100 West Big Beaver || ***A* **** ||Troy, MI 48084 || **** **** ||(810) 643-5078 ||=============== *M** **** ===============||uunet!kmart!jregep