+ Reply to Thread
Results 1 to 5 of 5

obtain specific rows and column from access table

  1. #1
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Question obtain specific rows and column from access table

    Hi All,

    i'm wanting to loop through an access table and pick out specific fields from each recordset. for example i want the first and third field of every row?

    i can extract all of the record easily just struggling to do this?

    For simplicity sake lets just say my database is "c:\database.mdb" and my table is called "table" and the fields are called F1, F2 and F3.

    i assumed it would be similar to an array so (this would select row 1 column 1):

    Please Login or Register  to view this content.
    any help is really appreciated.
    Last edited by Macdave_19; 10-18-2010 at 07:44 AM.
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,806

    Re: obtain specific rows and column from access table

    Hi Macdave_19,

    I thought the way to do this was to create an Access query and only drag the fields you want to the query table. Then when you run the query only those fields appear. Do a Make Table with this query and you don't have to worrry about filtering them with Excel.

    Is that what you wanted?

  3. #3
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: obtain specific rows and column from access table

    Hi Mate, not quite.

    i am basically trying to populate a treeview with the data. but i'll need all the fields but only want to show certain ones, does that help?

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,806

    Re: obtain specific rows and column from access table

    Hi,

    I guess I need an example. I don't understand "treeview" well enough to help. Perhaps someone else can jump in.

  5. #5
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: obtain specific rows and column from access table

    I've sussed it out:

    Please Login or Register  to view this content.
    Hope this helps folks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1