put some <@if> logic in the loop so that the teacher only displays if the current value changes from the previous value.
Before you start your loop, assign a value to HoldTeacher. just inside your loop compare current value of teacher to holdteacher... if it is the same, do nothing, else display it, and assign the current value to holdteacher... continue with your loop processing. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Stein Sent: Tuesday, August 27, 2002 11:20 AM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Help with <@ROWS> or <@For> I have a search action that returns a list of courses that teachers have taken The values Staff_ID Course_ID Title First_Name Last_Name Location_ID Location Compensation I would like to return a report that looks like this Building ( location) Teacher Course Number Course name Compensation Teacher Course Number Course name Compensation Etc. For now I can have them do one building at a time but the list would look best if teacher names only showed when there was a new teacher in the list. I've attached what I have so far. I think I am close but just can't grasp the logic for the teacher loop. -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
