i have 2 tables one called stocklist and another called stocknumber of which the stocknumber table could vary with data
what i want to do is copy data into the table called stocknumber and then do a query that will tell me the stock numbers that are not in the table called stocklist but i am getting is wrong information it just shows me blanks for the 3 lines are are not in the stocklist i copied the 10 lines from stocklist to stocknumber and change 3 line items so i want to only see the 3 lines that i changed as they are not in the table called stocklist
thanks steve
what i want to do is copy data into the table called stocknumber and then do a query that will tell me the stock numbers that are not in the table called stocklist but i am getting is wrong information it just shows me blanks for the 3 lines are are not in the stocklist i copied the 10 lines from stocklist to stocknumber and change 3 line items so i want to only see the 3 lines that i changed as they are not in the table called stocklist
thanks steve