[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
10/29/2009 at 10:28AM PDT, ID: 24855410 | Points: 50
[x]
Attachment Details

Compairing mupltiple fields

Asked by tparvaiz in Microsoft Access Database, Access Reports

Tags: MS Access

I have 2 tables in MS Access...

I want to compare 9 fields from both the tables to ensure that it's an exact record... How can I do it...

to compare 1 field I've used the following query

select a.field1, a.field2
from
table a
where a.field1 not in (select b.field1 from table b);

not sure how to modify it to compare multiple fields...

Also, my tables are bigger in size (400k+ records) so I would prefer an efficient query...

Thanks
[+][-]10/29/09 10:36 AM, ID: 25696123

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/29/09 10:38 AM, ID: 25696141

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/29/09 12:04 PM, ID: 25697057

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/29/09 03:24 PM, ID: 25698856

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625