I have a report that is sorted by employee id and then the date and then the job number. I need to total the number of unique job numbers for each employee and cannot seem to arrive at a correct report set up for this. What happens is that if a job is worked on during several different days and maybe even skipping some days the count gets thrown off. Any suggestions?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.