This may get you started in the right direction: SELECT EmpName, SUM(IFEQ(actiondate,'06/09/2009',actions)), SUM(IFEQ(actiondate,'06/16/2009',actions)), SUM(actions) FROM tablename group by EmpName
Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Friday, June 19, 2009 2:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - View Construct Group, I need to construct a view that compares actions by an employee made last week to this week. So it's a single table view and would look something like EmpName 06/09/2009 06/16/2009 Result Joe Shmoe 1 1 Snuffy Smith 1 1 2 I'm drawing a blank. Jan
