Duplicate records in query

[vnms2001]

I have 4 tables that I combine in one query. How can I avoid generating duplicate records of one name. For example: Sam has four different insurance premiums, dental, vision, medical & RX. I don't want to see his name comes up in query four times. I would like to see his name once and four insurance premiums same line along with his name. Please help.

Thanks

[ranman256]

make another query ,based on your query,
pull only the NAME and set the query property: UNIQUE VALUES = YES.

now you wont see duplicates.
if you add more fields, you will see duplicates.

[vnms2001]

How can I setup UNIQUE VALUES = YES