Advertisement

07.23.2008 at 08:24AM PDT, ID: 23588856
[x]
Attachment Details

Query to compare two fields - Access 2003

Asked by Pdeters in SQL Query Syntax

I have an Acess 2003 table
I hve a total of 10 fields. I want to tkae two fields and match them up to another table with the same fields - if one field matches and the second field does not  - show that record in the queryStart Free Trial
[+][-]07.23.2008 at 08:40AM PDT, ID: 22070421

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: SQL Query Syntax
Sign Up Now!
Solution Provided By: kuintencst
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.23.2008 at 08:58AM PDT, ID: 22070622

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.23.2008 at 09:55AM PDT, ID: 22071258

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 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628