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
