Comparing data on record at a time

[csou5555]

Hi - I'm working on a query, and can't seem to get it to work correctly. I have a table which contains 2 social security number fields - one for a dependent/employee with benefits, and one for the originally insured (for example, if an employee passed away, the dependent would be on the file, and the originally insured data would be populated with the original employees data). There are also cases where the employee and dependent exist in the table at the same time. I need to check the table, record by record, to identify any cases where the two SSN's are the same in any given record. The query is currently finding an employee's SSN on their record, and also finding it in the originally insured field of the dependent's record and showing it as an error. I only need to know if they occur for the same record, not for another record in the table. (I hope this makes sense!!!)

Is there any way that I can do this??? Any help would be greatly appreciated!!!!

 

[KeithG]

you can create a join between the two fields

 

[csou5555]

Join based on one table?

I didn't know you could do a join when you are only utilizing one table. How is that possible?

 

[KeithG]

Go to the add tables button and add a duplicate copy of the table.

 

[csou5555]

Worked!!! Thanks!!

Thanks! Worked like a charm!