<% Do While NOT RecordSet.EOF If this_state_name <> RecordSet.Fields.Item ("state_name") Then ' We have not seen this state before.' ' Set it for next time.' this_state_name = RecordSet.Fields.Item ("state_name") ' Show the state's name in its own table row.' %> <% End If ' NOT this_state_name = RecordSet.Fields.Item ("state_name")' %> <% RecordSet.MoveNext Loop %>

<%=RecordSet.Fields.Item ("state_name")%>

"><%=RecordSet.Fields.Item ("installation_name")%>