How do I insert code after a certain number of data sets

Results 1 to 2 of 2

Thread: How do I insert code after a certain number of data sets

  1. #1
    Join Date
    Dec 1969
    Posts
    206

    Default How do I insert code after a certain number of data sets

    I would like to insert html inbetween every third data set and the next one in line. The reason is purely superficial in that it is to make the results look nice, lined up three in a row and then moving to the next line. If there is another way, please let me know. Thanks for your help.<BR><BR>Brandon

  2. #2
    Brian C. Guest

    Default RE: How do I insert code after a certain number of data sets

    You need to use MOD. Have a counter, and everytime that counter MOD 3 equals 0, do your stuff.<BR><BR>Dim iCounter<BR>iCounter = 0<BR><BR>Do while not rs.eof<BR><BR>if iCount mod 3 = 0 then<BR>&#039display your line breaks<BR>end if<BR><BR>&#039display your recordset stuff<BR><BR>rs.movenext<BR>loop

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •