Comparing data across record lines in queries

[rotorque]

I can not find a way of comparing records across a table so that I can select only one of the same occurrence of the record. For example if you can picture a person’s job history 10 years. They have an entry each year containing the same job details. I only want to pick one of these but for those that have multiple different records I want to select all of them. Hope this makes sense. Any assistance would be really helpful.

Thanks

 

[MSAccessRookie]

I can not find a way of comparing records across a table so that I can select only one of the same occurrence of the record. For example if you can picture a person’s job history 10 years. They have an entry each year containing the same job details. I only want to pick one of these but for those that have multiple different records I want to select all of them. Hope this makes sense. Any assistance would be really helpful.

Thanks

Would it be possible for you to be able to post a description of the Table involved? No data is necessary, just the Column Names and Types. It sounds like there may be a design issue here.

 

[alktrigger]

If I understand correctly, you could possibly do a sum by group query, then using those results to select records from individuals based on the size of the count (i.e. use [count] >1 in the criteria

 

[lution]

Sounds like a "select distinct" type query. You'd want each distinct name, job description for each person.

example: select distinct <employee id>,<job description> from <tablename>

Where it gets sticky (for me at least) is if you need to total the number of years at each job description.

Hope this helps,
Lution