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.
right click on the black line between the tables boxes
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
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.