Jump to content

Summarize number (count) of unique dates


This topic is 2388 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2388 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.