>> and want it to find all those that match a particular date (field2),
>then return
>> sums for each field1... using the above table should generate the following
>> result for field2=12345
>
>select
> field1,field2,sum(field3) as total
>from
> table
>where
> field2=12345
>group by
> field1, field2
>;
forgot to group by both fields that were not in the sum function...
beautiful... thanks to those who responded.
Dave