I have a query with the following
field: Number
table: membership
total: group by

field name
table results
group by

field winnings
table results
sum

field P
table results
group by

field C
table results
group by

field event
table results
group by

when i run the query it shows for each event entered the total winnings at
each rodeo that is marked P and the total winnings at each rodeo marked C for
each member. This is done by showing the name twice for each event entered.

I would like the report to show the members name and number once and than
show total for C rodeo and total for P rodeo and a total of both P and C in
one line. How do I do this?