Another Comparing Tables Post

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables - A & B. Each table has the same account number field. I need to see if there are any account numbers in table B that match the account numbers in table A. How can I do this.......

Please help!!!!
Thanks
 
Hi,

Have you tried using the "Find duplicate query wizard"?

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."


--------------------
| Thread-Topic: Another Comparing Tables Post
| thread-index: AcPfnWh9b9i847d4Qti0U7mZ6l1jWA==
| X-Tomcat-NG: microsoft.public.access.queries
| From: "=?Utf-8?B?Sm9obiBLLg==?=" <[email protected]>
| Subject: Another Comparing Tables Post
| Date: Tue, 20 Jan 2004 13:36:05 -0800
| Lines: 4
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.queries:186942
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.queries
|
| I have two tables - A & B. Each table has the same account number field.
I need to see if there are any account numbers in table B that match the
account numbers in table A. How can I do this.......

Please help!!!!
Thanks
|
 
Put both tables into one query and join them on the account number. The query
will only return those records where the account number match. Or do you need
all the records in table b to show up, and want to flag those that have a match
in table a?
 
Back
Top