Unmatched Query

[Kathy Wilson]

Hi,
I know how to do an unmatched query but is it possible for
me to show the unmatched results from BOTH tables in one
query or report?

I have 2 tables and both tables have the fields COURSE and
SECTION. The courses and sections are suppose to match.
I need a unmatched query that will show me any
courses/sections that don't match but i want to see side
by side the unmatched records from both tables in one
query. Right now i'm only getting the results from one
table.

thanks
Kathy

 

[John Vinson]

I know how to do an unmatched query but is it possible for
me to show the unmatched results from BOTH tables in one
query or report?

You need to create two unmatched queries - finding the Courses with no
Section, and the Sections with no Courses - and then use the UNION
operator to combine them. See the online help for UNION.

For ongoing use, you should really consider creating a Relationship
between the Courses and Sections tables, with relational integrity
enforced. In my (admittedly long ago) educational experience, a
Section without a Course would be an error from the start, and should
simply not be allowed to exist!

 

[Kathy]

thanks for the help john,
oh i'm sorry, all of the sections have courses. i'm doing
this for data entry clerical errors. the table holds all
of the courses with it's corresponding sections.
unfortunately we get this table as a text file and it can
contain duplicated courses but only 1 unique section.
this table is set in stone.

we do data entry by selecting a teacher then putting in
the course and section that he/she teaches. i just want
to make sure that we entered the correct course and/or
section by showing what we entered and what's actually in
the table that holds these courses.

i get your drift though and thanks. we only check 3 times
a year (that's when we do data entry).

oh by the way once we do data entry that data goes into
seperate tables.

kathy