I have a report which brings up all our candidates that we have sent to a particular customer. I need the first name and last name fields to not show up up when they have been sent twice for two diffrent job orders. but when i hide duplicates if anyone has the same last name it blanks thier last name out like manning gordon and then James blank. Does anyone know of a way to tie them together so only when the first and last names are the same they'll hide?

figured itout i joined the two fields and used that to match.