Jan, Can't you do a crosstab?
CROSSTAB COUNT actions FOR actiondate BY empname FROM tablename Dawn Hast [email protected] wrote on 06/19/2009 03:45:46 PM: > 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 DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Evergreen Packaging is not responsible for any changes made to this message and / or any attachments after sending by Evergreen Packaging. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
