Query Issue

[psycoperl]

Hi all,
I am trying to update this query to allow me to Limit to a single month (i.e. August 2011) the tblActivityLog.ActivityDateTime contains a timestamp based on now() for each record.

any assistance you can provide would be apreciated.

SELECT tblUsers.OTEID, tblActivityLog.ActivityDateTime, 
     tblActivityCodes.ActivityCatergory, tblActivityCodes.ActivityDescription, 
      Count(tblActivityLog.TrackerID) AS CountOfTrackerID
FROM ((tblActivityCodes INNER JOIN tblActivityLog 
          ON tblActivityCodes.ActivityCode = tblActivityLog.ActivityCode) 
    INNER JOIN tblSource ON tblActivityLog.SourceCode = tblSource.SourceCode) 
    INNER JOIN tblUsers ON tblActivityLog.OTEID = tblUsers.OTEID
GROUP BY tblUsers.OTEID, tblActivityLog.ActivityDateTime, 
        tblActivityCodes.ActivityCatergory, 
        tblActivityCodes.ActivityDescription;

 

[Joe4]

Here's one way:

SELECT tblUsers.OTEID, tblActivityLog.ActivityDateTime, 
     tblActivityCodes.ActivityCatergory, tblActivityCodes.ActivityDescription, 
      Count(tblActivityLog.TrackerID) AS CountOfTrackerID
FROM ((tblActivityCodes INNER JOIN tblActivityLog 
          ON tblActivityCodes.ActivityCode = tblActivityLog.ActivityCode) 
    INNER JOIN tblSource ON tblActivityLog.SourceCode = tblSource.SourceCode) 
    INNER JOIN tblUsers ON tblActivityLog.OTEID = tblUsers.OTEID
[COLOR=red]WHERE FORMAT([tblActivityLog].[ActivityDateTime]."mmyy")="0811"[/COLOR]
GROUP BY tblUsers.OTEID, tblActivityLog.ActivityDateTime, 
        tblActivityCodes.ActivityCatergory, 
        tblActivityCodes.ActivityDescription;

 

[psycoperl]

Thanks so much...