?
Solved

Find match in access

Posted on 2006-04-04
1
Medium Priority
?
241 Views
Last Modified: 2006-11-18
Hi,

I have 2 tables in access that have a common ID. In access there is a query to find unmatched records in 2 tables, but i need is a query to find matching records in 2 tables.
Thank you.
0
Comment
Question by:Ygal_Benabou
1 Comment
 
LVL 5

Accepted Solution

by:
DolGuldur earned 300 total points
ID: 16371672
You could do a simple query in Access using both table, in the query window, you link the tables with the common id fields and it will return the records where the id is equal.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
Today as you open your Outlook, you witness an error message: “Outlook is using an old copy of your Outlook Data File…”. Probably, Outlook is accessing an old OST file.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

621 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