Thanks for your (and everyone else here's) expertise and kindness in sharing your knowledge.  I am in your debt.

This seems to work exactly right when I ran your test, but when I tried plugging my table/field names in ... I ran into trouble...

My field names are Permnum,Lastname,Firstname,Birthdate

Table name...

Thanks the the reply..  

This query is returning all duplicates based on the FN,LN,Bd whether or not the records returned have the same PERMNUM (student ID) ...  the same as...

The result this one produces is the same as I got with the derive Access find duplicates code...... the problem being, it is finding the duplicates based upon same FN,LN,BD, ...

No Problem ... my head is very large... so beware the choking hazard!!!!

LOL 

Very interesting solution here... elegantly simple, but perfect.  

If I may, I am wondering how your query could be modified to enable me to see each of the duplicate entries in...

Is there ameans to attach an excel spreadsheet with some generic data?   I'm looking .. but not seeing....

You're right... I just dropped that in during some testing .. .forgot to take it out before posting.  

What I'm trying to do here is find rows in the table...

Thanks .. this did produce a result set, but also removed the flag column, which is a problem...    Here's what I'm trying in my ham handed way to do....

I need...

Tried that... got the same message... puzzling... 

What I'm trying to do here is find rows in the table where the Concschool field  (school a student is concurrently enrolled in), the...

Thanks.. what should it be ???