Results 1 to 5 of 5

Thread: Filter by table *resolved*

Threaded View

  1. Sep 10th, 2002, 02:24 AM #1
    Feetstink
    Feetstink is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2002
    Location
    Grand Rapids, MI
    Posts
    166

    Filter by table *resolved*

    I have 2 tables, tblIssues and tblTypes

    I want to filter the recordset a couple times by each record in tblTypes. For example,

    tblIssues has 4 columns,

    ID, p_id, summary and type_id

    tblTypes has 2 columns

    type_id, type

    tblTypes looks something like

    1 Dates
    2 Modifications
    3 Request
    4 Telemarketing

    each issue would be one of these types. I want to display all the issues in 4 separate tables, one for each type.
    Currently my recordset contains all the records. I know i can filter using the rs.Filter, but how can i loop it so that it filters and displays by each type in tblTypes?
    i know this sounds kind of confusing but I don't know how to explain it better.
    thanks.
    Last edited by Feetstink; Sep 10th, 2002 at 04:01 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width