I want to group by two fields. I can't seem to get it to work. This is the code I have:
Error message I get is "Report Sections do not match data source"Code:SHAPE{SELECT TblUsers.UserName,TblTimeTable.LogInDate,TblTimeTable.LogInTime,TblTimeTable.LogOutDate,TblTimeTable.LogOutTime,TblTimeTable.SessionName FROM TblTimeTable INNER JOIN TblUsers ON TblTimeTable.UserID = TblUsers.UserID WHERE TblTimeTable.LogInDate BETWEEN #" & Format(strFromDate, "mm/d/yyyy") & "# AND #" & Format(strToDate, "mm/d/yyyy") & "# ORDER BY [TblUsers.UserName],[TblTimeTable.SessionName]}" & "AS SQL1 COMPUTE SQL1 BY UserName,SessionName"
It's probably something very easy, but I can't seem to figure out what it is... I'm a complete newbie in using report designers... Your help is appreciated! ;-)


Reply With Quote
