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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jann - 24 Mar 2006 09:21 GMT

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.

Reply to this Message

George - 24 Mar 2006 12:17 GMT

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" έγγραψε:

> 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
[quoted text clipped - 3 lines]
> two tables and there are duplicate records. What do I need to do? I don't
> know SQL yet.

Reply to this Message

Jann - 24 Mar 2006 16:30 GMT

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

> Hello Jann,
>
[quoted text clipped - 14 lines]
> > two tables and there are duplicate records. What do I need to do? I don't
> > know SQL yet.

Reply to this Message