> >
> >
> >
> > * Select TOQtemp
> > * Goto Top
> > * Those two lines are superfluous. A SELECT SQL query opens the table in
> > * the FROM * clause and reads it straight from the harddisk.
> >
> >

 
> > Select field1, field2,P_ID,;
> >  Cast(Sum(field4) As N(12,2)) As item1,;
> >  CAST(Sum(field5) As N(12,2)) As item2,;
> >  CAST(Sum(field6) As N(12,2)) As Total;
> >  FROM TOQtemp ; 
> >  Group By P_ID, field1, field2
> >  Browse
> > 
> > Note 
> > * Select field1, field2, P_ID
> > * Group By P_ID, field1, field2 
> > * Same columns in SELECT and GROUP BY lists. 
> > * The rest of the columns are all SUM() aggregations.
> > * You cannot SELECT nor GROUP BY a column that is aggregated in a SUM() 
> > 

> > -Anders
>
> Works great, but one question, how can I show fields I do not want to group by ? Main part of this is I have mulipal accounts with different account # but the same P_ID so I need one record for the reports that shows total for all those records ?
>
> Ryan J. Lashway
> http://www.lashtech.com

Are yoy saying that you want two levels of summing in a single query: A sum for account numbers group, and a sum for each p_id group.
That's fairly easy in a Report based on a query cursor with ORDER BY p_id, account_no
You can simply run two separate queries with GROUP BY account_no in one and GROUP BY p_id in the other
If you could post some minimal data set that shows an example of this + the result as you want to see it based on those records I will try and solve the problem.
The best way to show data so that everybody here can have a go at it is with

CREATE CURSOR xx (,,,,) 
INSERT INTO xx VALUES ( ,,,, ) 
INSERT INTO xx VALUES ( ,,,, ) 
INSERT INTO xx VALUES ( ,,,, ) 

Expected result:

 col1, col2, col3 
 ..   ... ....
 ..   ...  .... 

-Anders