record search criteria

Posted on 2008-02-06
Medium Priority
Last Modified: 2008-03-06
I have 2 tables, Hisory and Core Pin History, they both have a field labled ID.  I use that filed to tie the table together for data entry on the same form.  That field is populated in the History table and copied to the Core Pin History table but only if the use enters data in the fields that go with Core Pin History.  If they don't enter data into Core Pin section then no data is entered into the Core Pin history table.  So now i can create a query and link the 2 fields in the query and get records from both tables that have matching ID's but i need to know is how do i get only the records in the history table that have ID's that do not have any matching ID numbers in the Core Pin History table?
Question by:AisinAuto
1 Comment
LVL 28

Accepted Solution

TextReport earned 1500 total points
ID: 20834263
You use the LEFT OUTER JOIN with a where like below.
Cheers, Andrew

FROM History H LEFT OUTER JOIN [Core Pin History] C ON H.ID = C.ID

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question