Paul, That's what "summaries of groups" is for. Drag the column for which there are eight different values into the list of "Select Columns" and also into the list of "Group By Column." Then drag any other column that will not be null into the "Select Columns" list, and choose "Count" for its function.
In a DBMS action, you wouldn't use a column name for the COUNT, but would use an Asterisk, as below. COUNT isn't really counting any particular column, it is counting ROWS within each group. The SQL you are generating would look like this: SELECT column, COUNT (*) FROM table GROUP BY column Bill On Tue, 14 May 2002 11:24:33 -0500, Storey, Paul wrote: >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
