Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Records to separate (Access2003)

    I am having records

    AAA___2
    AAA___3
    AAA___4
    AAA___5

    BBB___3
    BBB___4

    CCC__2
    CCC__1

    I need to pull records that are = 5 into Bucket5 table.
    Those records that have no 5s in ALLBucket table.

    So AAA records are belong into Bucket5 table.
    BBB and CCC are in ALLTable. No AAA records in ALLBucket.

    I am having a problem separating those AAAs from the rest.

    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Records to separate (Access2003)

    Create a query that looks for records that have a bucket 5 then group on the AAA field.
    Create a second query linking the new query with the original datasource. The link would be on the AAA field

    See attachment.
    Attached Files Attached Files

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Records to separate (Access2003)

    I realized you may be looking for the added step after I posted my first responce.

    Create a query that looks for records that have a bucket 5 then group on the AAA field. (the qryGet5s query in attachment)

    To see which "families" have a 5 bucket associated (the qryHas5s query in attachment)
    Create a second query linking the new query with the original data source. The link would be on the AAA field

    To see which "families" do not have a buck 5 associated (the qryNo5s query in attachment)
    Create a query with the data source linked into the first query(qryGet5s) using a greater than linking from original data source to the query. The criteria on the Family would be "Is Null" (no quotes

    See attachment.
    Attached Files Attached Files

  4. #4
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Records to separate (Access2003)

    Thanks so much, it was neat idea!

Posting Permissions

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