I have a database that tracks employee jobs that are completed on a given day.  I have a summary report that provides the total number of records for each employee, however, I wish to also show the number of days (unique dates) that were spent completing the jobs so as to provide a summary (by employee) with number of records and number of days.

I've bene unsuccessful finding a solution to count unique dates.

 

Ideas?

Create a sub-summary part when sorted by date, put that below your employee sub-summary, and sort by employee/date.

49 minutes ago, Bill_misc_IT said:

I wish to also show the number of days (unique dates) that were spent completing the jobs so as to provide a summary (by employee) with number of records and number of days.

See if this helps:
http://fmforums.com/topic/61158-number-of-employees-from-payroll-report/?do=findComment&comment=289204

 

P.S. Are you really using version 10? There might be a better alternative for version 13 or higher, using the 'List of' type of summary field.

Thanks all.  I was able to make the inverse solution work...just need to verify the accuracy of the data.  @consultant  I'm on FMPA 14 and have updated my profile.  Thanks for the heads up.