Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    139

    Unanswered: Defined criteria in append query

    I have an append query that I want to pull only the order#'s that appear in another table. I am wondering how to write the criteria to accomplish this task. Here are the particulars.

    In the criteria section of the ORDER field in this query. This query is being pulled from the ROTIME table. I would like only the records where the ORDER field matches the RO field in the SR ORDER table.

    Any suggestions of how to accomplish this would be appreciated.

    Thanks,
    B&R

  2. #2
    Join Date
    Feb 2007
    Posts
    348
    could you use a matching query and point at that?
    or Where ROTIME.ORDER in SR ORDER.SR?

  3. #3
    Join Date
    Feb 2004
    Posts
    139
    Works great and so simple.

    Thanks for the help!
    B&R

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    or

    in the design view of the Qurey

    right click on the black line between the tables boxes

    join properties


    there are three options

    only include rows .....
    include all rows form .... table1 edual to table2
    include all rows from .... table2 edual to table1

    wording some like that

    just pick the right one

    then you mite have to use a null in the Criteria to only show the data you want
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  5. #5
    Join Date
    Feb 2007
    Posts
    348
    Quote Originally Posted by B&R
    Works great and so simple.

    Thanks for the help!
    B&R
    w00t I helped for once

Posting Permissions

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