OK, I know of this. What I am looking for is a way to total a
currency column with the dataset has posted the current record. I
want to display the total of that column. Didn't want to loop
records to get this, if possible.

Thanks.

> I mean something like this:
>
> select street, count( shop ) as num_shops
> from shops
> group by street