Help designing report

[Guest]

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?

 

[John Nurick]

Hi,

Create a crosstab query that gets its data from your existing query and
arranges the data the way you describe, and then base a report on it.