it cut off my code. sorry -paul
<TR ALIGN="left" VALIGN="top"> <cfloop index="LoopNumber" from="1" to="#NumberOFColumns#"> <td colspan="5" valign="top" nowrap> <cfif LoopNumber eq NumberOfColumns> <cfloop query="Employees" startrow="#row_start#" endrow="#count_rows#"> <CFOUTPUT QUERY="Employees" GROUP="StudioName"> <tr> <td colspan="5" align="left" valign="top" class="small"> #Employees.City# -#Trim(Employees.StudioName)# </td> </tr> <cfoutput group="fullname" groupcasesensitive="Yes"> <table width="210" border="0" cellspacing="0" cellpadding="0" class="small"> <tr align="left" valign="top"> <td width="100" align="left" nowraps class="small">#Employees.Fullname#</td> <td width="10" align="left" nowrap class="small"> </td> <td width="10" align="left" nowrap class="small">#Left(Employees.floor,2)#</td> <td width="10" align="left" nowrap class="small"> </td> <td width="80" align="left" nowrap class="small">#Trim(Employees.PhoneNumb)#</td> </tr> </table> </cfoutput></cfoutput> </cfloop> <cfelse> <cfloop query="Employees" startrow="#row_start#" endrow="#row_end#"> <CFOUTPUT QUERY="Employees" GROUP="StudioName"> <tr> <td colspan="5" align="left" valign="top" class="small"> #Employees.City# -#Trim(Employees.StudioName)# </td> </tr> <cfoutput group="fullname" groupcasesensitive="Yes"> <table width="210" border="0" cellspacing="0" cellpadding="0" class="small"> <tr align="left" valign="top"> <td width="100" align="left" nowraps class="small">#Employees.Fullname#</td> <td width="10" align="left" nowrap class="small"> </td> <td width="10" align="left" nowrap class="small">#Left(Employees.floor,2)#</td> <td width="10" align="left" nowrap class="small"> </td> <td width="80" align="left" nowrap class="small">#Trim(Employees.PhoneNumb)#</td> </tr> </table> </cfoutput></cfoutput> </cfloop> <cfset row_start = row_start + #NumberFormat(DivCol, "9999")#> <cfset row_end = row_end + #NumberFormat(DivCol, "9999")#> </cfif> </td> </cfloop> ok this is going to sound long i have a phone list [we all do!] i can group by studio & display in one column employee phone info & such or if i write it a different way i can show all office info LOOPed into 3 columns. But i cant seem to do both! I would like to use a group by studio like i have, but display employee info top, down the right top, down & again in 3 culms i have tried a few different ways & just keep getting deeper... Any help would be wonderful! Thanks ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
