crosstab query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

B Earl - 19 Jan 2005 07:39 GMT

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

Reply to this Message

- 19 Jan 2005 12:46 GMT

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

>-----Original Message-----
>Let me try this again. I am stuck. I have a crosstab query with the persons
[quoted text clipped - 3 lines]
>one event. Is there a way to do this? Thanks
>.

Reply to this Message

B Earl - 20 Jan 2005 04:13 GMT

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?

> hi,
> assuming that your data is in a table, write another query.
[quoted text clipped - 16 lines]
> >one event. Is there a way to do this? Thanks
> >.

Reply to this Message