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
