Thank you very much.
Sorry to be unclear, they are time stamped, and I wondered if someone
could give me ssome advise how I do this aggregation. In particular do
I not know how to write such a scalar function.
Anything re-usable lying around as examples somewhere?
el
on 10/4/06 9:46 PM Guy Rouillier said the following:
> Eberhard Lisse wrote:
>> I receive payments, but not every day (or even every week),
>> and I would like see how much I receive per week and/or per month. I
>> also need to compare different years.
>>
>> I also would like to see what the (accumulated) sum of the payments
>> is at the end of a given week, month.
>
> Timestamp each transaction, then use a GROUP BY clause to aggregate the
> numbers however you wish. If the available date field extractions are
> not sufficient, write a scalar function of your own to accomplish what
> you need.
>
--
If you want to email me, replace nospam with el