Thanks, it works perfectly, and I have a much better understanding of the
interface.
John
> On Sun, 02 Mar 2003 19:05:18 +0000, [EMAIL PROTECTED] wrote:
>
> >Awesome, exactly what I needed. I could not get the group
> summary in
> >the search action to come up with that statement.
>
> >SELECT P1.StuID, count(P1.stuID) FROM
> dbo.ProjectRequestsUnique >P1 GROUP BY P1.StuID HAVING
> count(p1.stuid) = 31
>
> To get this query through the search action, drag a new Search Action
> into your taf, and then follow these steps:
>
> 1) Change "Select Type" from "Normal" to "Summaries of Groups"
>
> 2) Drag StudID and your unique ID to the "Select Columns" panel
>
> (Don't drag StudID twice: some data sources will interpret this as
> select count (distinct studentID)), which would always be "1" if the
> group by column was also studentID. For a COUNT, always drag a
> unique column)
>
> 3) Drag StudID to the "Group By Columns" panel
>
> 4) Change the "Function" for your uniqueID colum -- in the "Select
> Columns" panel from "MAX" to "COUNT"
>
> 5) Click the "Show Group Criteria" button at the bottom
>
> 6) Drag the "COUNT UniqueID" column bar from the "Select Columns"
> panel down to the "Group Criteria panel.. Change the Operator, Value,
> and Includ Empty and Quote Value settings appropriately.
>
>
>
>
>
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
