Can you show us the query that is giving you the incorrect results? I think I understand where you're going with this, but I'm not sure why you're getting the results you are.
> -----Original Message----- > From: mayo [mailto:[EMAIL PROTECTED] > Sent: Sunday, December 03, 2006 9:36 PM > > Instead I get results such all employees listed for each day > one of them > works. > > > > -------1-----------------2----------------3----------------4--------- > > + -------------- + -------------- + -------------- + -------------- + > > | 1/1 | 1/1 | 1/1 | | > > | 2/1 | 2/1 | 2/1 | | > > | 3/1 | 3/1 | 3/1 | | > > + -------------- + -------------- + -------------- + -------------- + ------------------------------------------------------------------------------ This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ============================================================================== "EMF <idahopower.com>" made the previous annotations. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
