Hi, I have a complex select statement that I need to execute and display the results in a table. The select is as follows
select taskId, activityDate, sum(effort) from TaskActivity where userid="2" and activityDate>="2004-04-10" and activityDate<="2004-04-16" group by taskId , activityDate order by taskId asc, activityDate asc; As I am using mysql as the database I don't have the luxury of having a view so is there any way using the limitations of dbforms can I execute and display the above results. Thanks, Sudeep. This message is confidential and may also be legally privileged. If you are not the intended recipient, please notify [EMAIL PROTECTED] immediately. You should not copy it or use it for any purpose, nor disclose its contents to any other person. The views and opinions expressed in this e-mail message are the author's own and may not reflect the views and opinions of ADP Wilco. ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
