I am new to ASP programming and would really appreciate some help.

 I am working on a page that gets records from an Access db. The records for

 each callID are numbered by initially CALLHIS5 then (possible)multiple

lines

 for each by CALL_TEXT_ .

 I am trying to loop through and get the records in the right sequence but

am

 becoming confused.

A sample table looks like:

Call_ID    CALLHIS5    CALL_TEXT_    Call_LN_TE_

123            0                    1                        Begining of

text up to 78 c

123            0                    2                        haracters

containing lots of t

123            0                    3                        ext for each

entry.

123            1                    1                        second entry of

text with

123            1                    2                        more text

123            2                    1                        record closed



 Someone at my office gave me the below code but its getting multiple Call

 IDs and not all the Text (I don't see any inner looping), and they are no

 longer available.

Can someone help me with code that would display the correct results. ?

 Thanks very much,

 Mitch

 --------------------------------

 Call_Num = 0

  DO WHILE NOT rs_details.eof



   ' added because I found lines with << embedded is resulting in loss text!

   NewLineT = Replace(rs_details("CALL_LN_TE").Value, "<", "--")



   if  rs_details("CALLHIS5").Value > Call_Num THEN

        strSolu=strSolu & "<P> [#" & rs_details("CALLHIS5").Value & " Date:

" &

 rs_details("LAST_UPDT_").Value & " Emply No: " &

 rs_details("DC_EMPL_NO").Value & "]  " & NewLineT

        CALL_Num=Call_Num + 1

   Else



         strSolu = strSolu  & NewLineT

   END If

  rs_details.MoveNext

  Loop