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 / General 1 / January 2006

Tip: Looking for answers? Try searching our database.

problems with a query or quaries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sparks - 30 Jan 2006 17:17 GMT
My boss just got some new data tables.

The problem is they are overlapping data and everything is fine.
UNTIL
ok show me everyone in table 1 that doesn't match anyone in table 2.
WHAT?

so he wants every name in one table that doesn't match someone in the
other table??????????

at first I tried to say if its in table 1 and not in table 2 include
it.

but I can't get it to work.
forget matching I need to find no match in a query.

what am I missing here...should this be easy?

thanks for any ideas

Jerry
fredg - 30 Jan 2006 18:11 GMT
> My boss just got some new data tables.
>
[quoted text clipped - 17 lines]
>
> Jerry

Click on Queries + New + "Find Unmatched Query Wizard"
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

sparks - 30 Jan 2006 19:21 GMT
thanks for your help fredg I had never used one of these before.
simple as pie

Jerry

>Click on Queries + New + "Find Unmatched Query Wizard"
 
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.