Filtering a Recordset Array

Results 1 to 2 of 2

Thread: Filtering a Recordset Array

  1. #1
    Needy Guest

    Default Filtering a Recordset Array

    Hi.... I have a record set array of numbers, I wish to step through the array and write out the values within the array.<BR> <BR>Say the array held the following:<BR><BR>0 , 100<BR>1 , 200<BR>2 , 300<BR><BR>and my search criteria value was = 110 ..... I would want to be able to write out the element in the array (first line (0) value 100) as it&#039;s &#060; 200. The same would apply if the new search value was 182 .... then i would still want to be able to select the first element. I hope this makes sense.<BR>

  2. #2
    Richard A. Lowe Guest

    Default RE: Filtering a Recordset Array

    Okay, (I think you asked this in another way in another forum, n&#039;est pas?), let me see if I&#039;ve got this right:<BR><BR>You want to take a value (search value: 110) and display the nearest single (i.e. only one output) value of in the array that is less than or equal to your search value.<BR><BR>In your example:<BR><BR>110 gets 100<BR>199.99999999 gets 100<BR>200 gets 200 <BR>4 gets ???? &#060;---- what would a &#039;4&#039; get you?<BR><BR>Richard?<BR>

Posting Permissions

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