Reply to thread

Message: [QUOTE="slotmgr70, post: 13521880"] Hi Clifford, I'm still getting an error, but it's probably because I'm not very good with SQL scripts. Here's the script I have so far. Can you take a look at it and suggest a solution: SELECT dbo_CDS_AUDITTRAIL.AuditGamingdate, dbo_PBT_PROMO_ADJUSTMENT.Player_ID, [dbo_CDS_PLAYER.lastname] & ", " & [dbo_CDS_PLAYER.firstname] AS [Player Name], [dbo_CDS_USER.lastname] & " ," & [dbo_CDS_USER.firstname] AS [Adjusted by] FROM ((((dbo_CDS_AUDITDETAIL INNER JOIN dbo_CDS_AUDITTRAIL ON dbo_CDS_AUDITDETAIL.AuditTrail_ID = dbo_CDS_AUDITTRAIL.AuditTrail_ID) INNER JOIN dbo_CDS_USER ON dbo_CDS_AUDITTRAIL.User_ID = dbo_CDS_USER.User_ID) INNER JOIN dbo_CDS_AUDITOBJECT ON dbo_CDS_AUDITTRAIL.AuditTrail_ID = dbo_CDS_AUDITOBJECT.AuditTrail_ID) INNER JOIN dbo_CDS_PLAYER ON dbo_CDS_AUDITOBJECT.Meta_ID = dbo_CDS_PLAYER.Player_ID) INNER JOIN dbo_PBT_PROMO_ADJUSTMENT ON dbo_CDS_PLAYER.Player_ID = dbo_PBT_PROMO_ADJUSTMENT.Player_ID WHERE (((dbo_CDS_AUDITDETAIL.Comments)=Trim(Right([COMMENTS],Len([COMMENTS])-InStrRev([COMMENTS],","))))) GROUP BY dbo_CDS_AUDITTRAIL.AuditGamingdate, dbo_PBT_PROMO_ADJUSTMENT.Player_ID, [dbo_CDS_PLAYER.lastname] & ", " & [dbo_CDS_PLAYER.firstname], [dbo_CDS_USER.lastname] & " ," & [dbo_CDS_USER.firstname], dbo_CDS_AUDITTRAIL.AuditEvent_ID HAVING (((dbo_CDS_AUDITTRAIL.AuditGamingdate) Between #9/3/2009# And #9/4/2009#) AND ((dbo_CDS_AUDITTRAIL.AuditEvent_ID)=2630)); [/QUOTE]