#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Oct 2013
    Posts
    1
    Rep Power
    0

    Trying to figure out an arrays 2 dimensional logic in an Access 2007 problem I have


    I have a table of 12,000 records with 10 columns (using Access 2007). I am trying to do a recordset to select from 2 columns and put those values in a column at the end of the table (both columns are sorted due to the nature of the data). One column is an ID column and the other column is a name column. While I am running the recordset, if the first ID column looks at the next row in the ID column and sees match AND if the Name column looks at the next row in the Name column and sees that there is a matching Name, then the ID column value is populated to an empty column at the end of the table. If any of those columns deviate from that condition (one column shows no match or both columns show no match), then the ID column and the name column from that row are appended and placed in a different column at the end. Basically the idea is that each row looks ahead to the next row to see what the field value of the ID or name (the values in these columns are based on a previous week’s report). Would anyone be able to help me with this code? Do I set it up with a muti-dimensional array or? Thank you.
  2. #2
  3. No Profile Picture
    Registered User

    Join Date
    Dec 2013
    Posts
    1
    Rep Power
    0
    It makes me so satisfied your vast understanding and wisdom have a new channel on the world.
    Glad i discovered this on google. You efforts to provide us so nice and useful information are pretty good.

Similar Threads

  1. Creating multi dimensional arrays on the fly
    By bough in forum ASP Development
    Replies: 2
    Last Post: August 31st, 2007, 11:11 AM
  2. Subscripts and dynamic multi-dimensional arrays
    By zanna5910 in forum ASP Development
    Replies: 3
    Last Post: July 14th, 2006, 09:16 AM
  3. Replies: 1
    Last Post: May 24th, 2005, 11:52 PM
  4. Replies: 2
    Last Post: February 24th, 2005, 03:53 PM
  5. Storing multi-dimensional arrays to a db...
    By Steve Schofield in forum ASP Development
    Replies: 2
    Last Post: April 4th, 2001, 03:46 PM

IMN logo majestic logo threadwatch logo seochat tools logo