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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly