S
Steven
I am working with a table with 15000 records that has a lot of repeat SSNs in
it. I want to get the unique SSNs so I did a query with only the SSN as an
output field and set the Unique Value to Yes. This shows me the all the
unique SSNs. The problem is I also want the other field values that go with
each unique SSNs and if it was a repeated SSN then just give me whatever
(like the field values on the first record for the repeated SSNs)
Note: I cannot do a Unique Value on the full table because the person put
for example records in the table:
Fields: SSN / LastName / Firstname
Record 1: 111-11-1111 / Smith / David
Record 2: 111-11-1111 / Smith / Dave
and on and on for about 10000 unique SSNs that ended up with a table of
15000 records.
So in this case I want to return only one of these records. Either name
would be ok. But I need SSN / LastName / Firstname
Thanks for your help.
Steven
it. I want to get the unique SSNs so I did a query with only the SSN as an
output field and set the Unique Value to Yes. This shows me the all the
unique SSNs. The problem is I also want the other field values that go with
each unique SSNs and if it was a repeated SSN then just give me whatever
(like the field values on the first record for the repeated SSNs)
Note: I cannot do a Unique Value on the full table because the person put
for example records in the table:
Fields: SSN / LastName / Firstname
Record 1: 111-11-1111 / Smith / David
Record 2: 111-11-1111 / Smith / Dave
and on and on for about 10000 unique SSNs that ended up with a table of
15000 records.
So in this case I want to return only one of these records. Either name
would be ok. But I need SSN / LastName / Firstname
Thanks for your help.
Steven