AnsweredAssumed Answered

Count of unique records

Question asked by lovelandj on Jan 15, 2018
Latest reply on Jan 16, 2018 by beverly

I have question on how to get the correct count of records. My table may have duplicate records because of a date change.  I don't care about the date change just need to show one of each name on the report.  I have about 3000 records per year.  I am using a find to get the records by calendar year. 

 

How and what could be the easiest way?

 

Example

First Name, Last Name, Date

 

Jane Doe  12/12/15

Jane Doe 12/13/15

Fred Doe 11/1/15

Henry Doe 12/12/15

Henry Doe 12/12/15

 

Output to a report

Jane Doe

Fred Doe

Henry Doe

 

Not

Jane Doe 

Jane Doe

Fred Doe

Henry Doe

Henry Doe

 

Thanks,

Jeremy

Outcomes