You are here:

Using MS Access/RE:MS Access query part II

Advertisement


Question
Thanks for your reply Scott
I need the ICMS_PSTN_EXCLUDE_CUST_NUMBER as it needs to exclude results which have that customer number in them

Let me explain what I expect the query to do
Table 1- ICMS_PSTN - This contains the PSTN records for the ICMS system
TABLE 2 - ICMS_SIEBEL - This contains the PSTN records for the Siebel system
TABLE 3 - ICMS_PSTN_EXCLUDE_CUST_NUMBER - These customers need to be excluded from the results

The query goes like this - Unmatched query based on customer number on Table 1 and Table 2 and based on the results it should exclude the results of all customer numbers in table3 - Hence the table is very important.

Also it is very strange I am not getting any emails from all experts hence cant rate or do a follow up question.

Appreciate your help!

Answer
Again, that is what the subquery does. You don't need to include Table 3 as a join because you use the subquery to do the exclusion.

Not sure why you aren't getting e-mails. You can log in to do see your questions to do followup and ratings.

Hope this helps,
Scott<>

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.