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.
--
Guy Rouillier