> When I try either suggestion I get a "SQL:GROUP BY clause is missing ot invalid.
>
>
>
> >
> >

select account, max(adress) as address, ;
> >  sum(item1) as item1, ;
> >  sum(item2) as item1, ;
> >  sum(total) as total ;
> >  from myTable ;
> >  group by 1

> >
> > Cetin Basoz
>
>
>
> Ryan J. Lashway
> http://www.lashtech.com

Ryan,
Sorry but that code wouldn't give "SQL:Group by clause ... " in any version of VFP nor in SQL server. Where does it give the error? VFP version? Native data or backend? I however made a typo and have 2 'as item1' (and adress/address). Are you sure your fieldnames are like that and SQL is not modified?

Cetin Basoz