crosstab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Let me try this again. I am stuck. I have a crosstab query with the persons
name as the row heading. The column heading is the event/events the person
has entered. The value is the sum of winnings for the event. I would like to
create a report that shows the peoples names that have winnings in more than
one event. Is there a way to do this? Thanks
 
hi,
assuming that your data is in a table, write another query.
SELECT tbl.Name, Count(tbl.Name) AS CountOfName, Sum
(tbl.Winnings) AS SumOfWinnings
FROM tbl
GROUP BY tbl.Name
WHERE (((Count(tbl.Name))>1));
use this query as the record source for your report
 
I am new to this, so i am guessing that you want me to use this in a select
query in a blank column in the field. When I do I get a syntax error. My
table is named rodeo results. it contains name, event,winnings, etc.

a little more information. in the table "rodeo results" a person can be
entered a number of times based on what rodeos he goes to. he will enter one
or more events each time he goes to a rodeo. each time he goes to the rodeo
he will be entered in the table once for each event he enters. on my form the
events are listed in a drop down box. what i need to know is the people that
have entered more than one event, for example a person can enter the tie down
roping and the team roping at each rodeo he goes to. so one person can be
entered a lot of times for one event or a lot of times for two events. Is
that what your query will do?
 
Back
Top