hiding duplicates

klr397

Registered User.
Local time
Yesterday, 16:58
Joined
Dec 13, 2005
Messages
30
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.
 

Users who are viewing this thread

Back
Top Bottom