Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / April 2006

Tip: Looking for answers? Try searching our database.

Display no-match between tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bryan W.H. - 20 Apr 2006 08:36 GMT
Access 2003

I have a table with the fields: LC, LC Name  where LC is the code for a
facility and LC Name is the Name of the facility

I have a second table that in imported from an external database with the
fields LC, LC Data  where LC Data is financial information.

The two tables are joined by LC.  I need to verify table 1 has up to date
information based on the LC records found in table 2.

I have a simple query with both tables in the query and LC as the field.  
The data returned is all LC records that match in both tables.  How do i
change this to show all LC records that are in table 2 but NOT in table 1?

Appreciate any help you can provide.
Delordson Kallon - 20 Apr 2006 09:17 GMT
In the query design view, right click on the line that joins the LC fields
from the two tables and click on 'join properties'. Select the option that
best suits the outcome you want.

Delordson Kallon
http://www.instantsoftwaretraining.com/

> Access 2003
>
[quoted text clipped - 12 lines]
>
> Appreciate any help you can provide.
Delordson Kallon - 20 Apr 2006 09:31 GMT
Hang on. I think I may have been too hasty there. The best method is to use
the "find unmatched query wizard" which is one of the options when creating a
new query.

Delordson Kallon

> In the query design view, right click on the line that joins the LC fields
> from the two tables and click on 'join properties'. Select the option that
[quoted text clipped - 19 lines]
> >
> > Appreciate any help you can provide.
Bryan W.H. - 20 Apr 2006 10:12 GMT
Thank you, sometimes things can be so easy, and right under your nose.

For anyone that might need more information on this.  To get to the find
unmatched query wizard click on the 'New' icon which is located next to
'Open' and 'Design' options while on the query screen.

Course if that is more confusing i apologize.

> Hang on. I think I may have been too hasty there. The best method is to use
> the "find unmatched query wizard" which is one of the options when creating a
[quoted text clipped - 25 lines]
> > >
> > > Appreciate any help you can provide.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.