Counting Group Members in a report

[Roni Sutton]

I have a report that is broken down by team and then by task. I want a count of unique tasks. However, there are multiple records in the detail that have the same task number. When I try to get a count, I get the total # of records in that task. How can I get it to tell me how many UNIQUE tasks are on the report? I have put the calculated unbound box in every area of the report and I either get an error or the total # of records for each task number. HELP!!

 

[andyh]

use a cross-tab query (similar to a piviot table)

experiment...