[AccessD] Unique Record Pull

Hello All,

I have run into a little snag on the project I am working on.  I have a
linked table from Oracle that contains records that have not passed a
verify process because they have something wrong with them in one of the
fields, in other words it does not meet the criteria.

Each record has a unique ID number and the same person can be repeated
many times.  For example one person can have multiple records in the
table with a different ID number but the same SSN number, last Name and
First Name.  

Here is where I have run into a snag, I want to be able to only pull
from the table one of these records for each SSN and I need it to show
the ID number of this record and display this set of records in a form
for the user to be able to scroll through.

Any suggestions?

Thanks,

Mike Gowey, MCP
Technical Support Analyst
SRCI ISSD Team Leader