Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
SELECT SUM(h.hours) as Hours, MIN(h.ActivityDate) as Min_Date, MAX(h.ActivityDate) as Max_Date FROM tblOrgRegistrations AS r INNER JOIN tblOrgHours AS h ON h.RegID = r.RegID AND Month(h.ActivityDate) = 7 INNER JOIN tblOrgActivities AS a ON h.ActivityID = a.ActivityID INNER JOIN tblOrgProfile AS o ON h.AgencyID = o.AgencyID Where o.AgencyID = 74 and Min(h.activitydate) = 7 Group By r.RegID,a.ActivityName, o.[Agency],h.Program, r.FirstName, r.LastName
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!