Michele, Could you provide an example of the statement, stripped down to what's necessary to demonstrate the problem?
-- Ken On 2/8/07, Michele Michele <[EMAIL PROTECTED]> wrote: > > OK, this is probably going to sound dumb, but I need to get a count on one > column in a long SQL statement where the rest of the columns are using > sum. My record count is only counting based on my search criteria, but I > need a count on the number of detail records form where it is getting that > information. Does that make any sense? > > Thanks for any help, I have so much to do I can't think! > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2721 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
