Append Query no Duplicates problem

Question

Hi all

I have a table that I import from our MIS

The contents of the table is: students names, their ID, Registration, the subject they are studying and the class they are in.

I then run a query to append all the students into a table (tblStudent) and another one to append all the classes into another table (tblClass)

These would only get one instance of each Student in the tbls and the tblClass would only have once instance of the class. Therefore the query has a code to remove duplicates.

The issue however is,  if a student only appears once because they are only taking one subject, they don't get appended in the tblStudent or if a subject only has one student that class doesn't get appended

Please can you look at the query and advise so that it doesn't only append what was duplicated. Hope that makes sense

The Append query's source is another query which is

DupExtract query

and the APPEND query is

Thank you

Answer 1

Why do you have criteria of >1? What happens if you remove this?

Answer 2

Hi thanks for your reply

Removed the >1 and it worked fine!

No idea why it was there. I pinched it from another database! 

Thank you

J