I think in that example, the "Unique values only" flag is relevant.
-----Original Message----- From: Storey, Paul [mailto:[EMAIL PROTECTED]] Sent: 14 May 2002 5:25 To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Search Actions I must be missing or misunderstanding something. I can use the sum function to get a total cost and display the results. But I think I'm having trouble understanding the purpose of the count function. Example: I have a database with 100 records. In one field there are eight different values. I am trying to count the number of occurrences for each value. When I use the count function it returns 8 in the resultset. -----Original Message----- From: Eric Weidl [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 10:34 AM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: Search Actions Hi, >I have gone through the documentation and cannot find how to return the >results after performing a search action with a select type of "Summaries of >Groups" or "Summary of All Rows". Will someone please point me in the right >direction. The same way you access the results from a "normal" search action. <@VAR resultSet> will show the entire results in an HTML table. You can also use the Snippets tab of the Workspace to access the specific columns. The columns will be named something like: <@COLUMN "MAX(myTable.myColumn)"> Eric ________________________________________________________________________ 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 ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
