Greetings,
I have a report based on a query. Since I have to track and display individual tasks per job number, the Job Number in the report produces duplicates which I suppress by not displaying them. The problem, however, is that I need a count of job numbers. How would I go about counting "distinct" job numbers? For instance, my september report should produce 89 jobs, but it shows 160 because it's not counting "distinct" job numbers. Any help would be greatly appreciated. Thanks in advance.
I have a report based on a query. Since I have to track and display individual tasks per job number, the Job Number in the report produces duplicates which I suppress by not displaying them. The problem, however, is that I need a count of job numbers. How would I go about counting "distinct" job numbers? For instance, my september report should produce 89 jobs, but it shows 160 because it's not counting "distinct" job numbers. Any help would be greatly appreciated. Thanks in advance.