SELECT 
		logs.UserName, 
		logs.CID,
		logs.logon,
		logs.logoff,
		logs.tot_min as day_min,
		sch.begweek,
		sch.RecID as wkRecID,
		logs.offline
	FROM 
		stu_logs logs INNER JOIN 
			[Term 5 Courses] course ON course.RecID = logs.CID LEFT JOIN 
			schoolweeks sch ON Cast(logs.logon as datetime) BETWEEN sch.begweek AND DATEADD(dd, 7, sch.begweek)
	Where 
		logs.UserName = 'jaban6988'
		and logs.CID = '19' 
		and logs.[yr/Term] = ('2006' + '5')
		and Current_Timestamp not between sch.begweek AND DATEADD(dd, 7, sch.begweek) 

LEFT JOIN
schoolweeks sch 
ON	Cast(logs.logon as datetime) >= sch.begweek AND
	Cast(logs.logon as datetime) <  DATEADD(dd, 7, sch.begweek)

quote:

---

Originally posted by Michael Valentine Jones

You have a logical error in your left join.

Try recoding it like this:

LEFT JOIN
schoolweeks sch 
ON	Cast(logs.logon as datetime) >= sch.begweek AND
	Cast(logs.logon as datetime) <  DATEADD(dd, 7, sch.begweek)

CODO ERGO SUM

---

LEFT JOIN
schoolweeks sch 
ON dbo.F_START_OF_WEEK(CAST(logs.logon as datetime),2) = sch.begweek 

	SELECT 
		sch.begweek,
		logs.CID,
		logs.UserName,
		SUM(logs.tot_min) AS wk_min
	FROM 
		stu_logs logs INNER JOIN 
			[Term 5 Courses] course ON course.RecID = logs.CID LEFT JOIN 
			schoolweeks sch ON Cast(logs.logon as datetime) BETWEEN sch.begweek AND DATEADD(dd, 7, sch.begweek) LEFT JOIN
			VerTime ver ON sch.recID = ver.week and logs.UserName = ver.UserName and logs.CID = ver.CID	Left Join
			PrblmTime prblm ON sch.recID = prblm.week and logs.UserName = prblm.UserName and logs.CID = prblm.CID	
	WHERE 
		logs.UserName = 'tester'
		and logs.CID = '19' 
		and logs.[yr/Term] = ('2006' + '5')
		and Current_Timestamp not between sch.begweek AND DATEADD(dd, 7, sch.begweek) 
	GROUP BY 
		ver.RecID,
		prblm.RecID,
		prblm.Active,
		logs.UserName, 
		sch.begweek,
		sch.RecID,
		logs.CID
	Order By sch.RecID