Ah Ha! I figured out the problem with the query. This following seems to work as expected:
SELECT dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, max(dbo.tblUserTransactionLog.Processed) AS LastTransaction FROM dbo.tblSubscribers, dbo.tblUserTransactionLog WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID AND (CONVERT(varchar, dbo.tblUserTransactionLog.Processed, 101) >= \'08/01/2007\') AND (CONVERT(varchar, dbo.tblUserTransactionLog.Processed, 101) <= \'08/01/2007\') GROUP BY dbo.tblSubscribers.SID, dbo.tblSubscribers.Username Thanks to Janet and Josh for their help! Thanks, - cwb ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
