Group by multiple fields

I want to group by two fields. I can't seem to get it to work. This is the code I have:

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"

Error message I get is "Report Sections do not match data source"

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! ;-)

Re: Group by multiple fields

Anyone got an idea? Or do you need more information?

Re: Group by multiple fields

it appears from the err msg the fields in the report is not available in the actual tables/ or in the datasource you created. Check the fields again...