Use the WHERE not HAVING clause. Try something like SELECT ... FROM ... WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID AND dbo.tblUserTransactionLog.Processed >= convert(datetime, '08/01/2007', 101) AND dbo.tblUserTransactionLog.Processed <= convert(datetime, '08/07/2007', 101) GROUP BY dbo.tblSubscribers.SID, dbo.tblSubscribers.Username,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
