How do I use Access to show duplicate records from two tables

[Guest]

I am new to Access and need help with a query to find duplicate records. The
situation is that I have a list of students who entered our college in the
Fall of year X. I need to see how many returned the next Fall of year X+1.
I created two tables with the data from the different years and created a
query. However, no data were displayed in the query table. I checked the
two tables and there are duplicate records. What do I need to do? I don't
know SQL yet.

 

[Guest]

Hello Jann,

Do you use two tables and in each one you record students? e.g. first table
for year 2005 and table 2006? If yes, although this is not a good practice,
is there any unique field like the studentID in both tables?

If yes you have to join both table using the unique field in the design of
the query.

Ο χÏήστης "Jann" έγγÏαψε:

 

[Guest]

George, yes - I have one table for 2005 and one for 2006 and each student has
a unique ID number. I did join the tables using the ID number but did not
get any results when I ran the "find duplicates" query. Am I missing a step
somewhere?
Thanks,
Jann