Guest User

Untitled

a guest
May 22nd, 2013
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. SELECT Count(tblMeeting.Meeting_Id) AS [Number of jobs]
  2. FROM (tblEmployee INNER JOIN tblMeetingType ON tblEmployee.Emp_Id = tblMeetingType.Chairperson_Id) INNER JOIN tblMeeting ON tblMeetingType.Type_Id = tblMeeting.Type_Id
  3. GROUP BY tblMeeting.MeetingDate, tblMeeting.AgendaApproved, tblMeeting.AgendaTopic
  4. HAVING (((tblMeeting.MeetingDate)>DateAdd("d",3,Now())) AND ((tblMeeting.AgendaApproved)=False) AND ((tblMeeting.AgendaTopic) Is Not Null));
Advertisement
Add Comment
Please, Sign In to add comment