Jan Is this what you are wanting to do.
create temp view tmppymtview (PaymentMonth,MTDAmount)AS SELECT (tmon(paymentdate)),mtdamount from detailpayments sel PaymentMonth,sum(mtdamount) from tmppymtview group by paymentmonth Buddy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Barley Sent: Thursday, October 09, 2008 1:14 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Group By Problems Hey everyone! If I create a view which contains a calculated column, can I later use that column in a group by clause? I'm trying to show invoice amounts by month. I don't really care what date the invoice is created, just the month, so I have a column in the view which grabs (tmon(idate)). I would like to be able to show only one row with the total invoice amount for the month - can I do this? Thanks so much! Jan Barley
