Splitting a recordset

Results 1 to 2 of 2

Thread: Splitting a recordset

  1. #1
    Join Date
    Dec 1969

    Default Splitting a recordset

    Hi,<BR><BR>I&#039;m creating a recordset (ordered alphabetically by one particular field) using an Access database. What I need to do is find some way of splitting the recordset into three equal (or as near as) parts, and displaying each part separately (in three table columns).<BR><BR>Is there an obvious way of doing this (in SQL / ASP terms) that I&#039;m missing?

  2. #2
    Join Date
    Dec 1969

    Default I don't quite understand, but...

    ...why don&#039;t you just chose only the columns you want and display them, i.e. if your recordset has 12 columns, you select columns 1 to 4, 5 to 8 and 9 to 12 and display them in a different colum. Or, if you have a large text field you want to split, just use the Mid() function and maybe Len() to get the length of the text. I&#039;m not sure what you mean though, so I might be talking out of my backside... :-)<BR><BR>Oliver.

Posting Permissions

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