Almost Jochem, I ran the query you sent to me but I only get a record count of 1 for each status now. I see what you are doing here. The inner query is onlu going to return one row per status. The outer query you suggested is only going to count the 1 row the inner query puts out for the status.
Maybe I can provide more clarification: I have a group table that can one or more tasks. The group is merely an umbrella that acts as a pointer to the tasks. The tasks contains all the data with regrads to amounts and dates. When you look at the group data it rolls the task data up to display it as a whole instead of indiviual tasks. In my current data I have two groups for the status of "New". The one New group has a group consisting of 2 tasks and another New group consisting of 65 tasks. My original sql would output a New group status count of 67(total tasks for two groups within this status) instead of 2(total number of groups for this status). When I add your additional code I get a total of 1 group for this status. I hope that helps explain it clearer. Your help is much appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
