Access Query duplicate records

[Riaang]

Hi there,

I have 2 tables that I need to link with one another by means of payroll number. The first table consist of only the main members detail. On the second table it has the main member and directly underneath with the same payroll number the detail of his family.

In my query I need to get all the detail from Table one and then only the main members ID number from table 2. In my result I get more than one record per member because it depends on the amount of family members he has in the second table.

How can I ensure that I only get one record per member in my result.

Please assist.
Thanks

 

[jobb]

try doing a calculated query for table 2 and "group by" the member info. Then in another query, connect table 1 to your calculated query.

hope that helps..

 

[Riaang]

Thanks, it seems to be working fine.