Microsoft SQL Server Query:

SELECT
EA7RECORDS.LASTNAME
, EA7COURSES.COURSENAME
, EA7ACADEMICYEARS.DESCRIPTION AS Year
, TABLEENTRIES.DESCRIPTION AS [Marking Column]
, EA7CLASSASSIGNMENTS.NAME AS Assignment
, EA7STUDENTASSIGNMENTS.GRADE
, EA7CLASSASSIGNMENTS.MAXPOINTS
, EA7STUDENTASSIGNMENTS.COMMENTS
FROM
(((EA7SESSIONS INNER JOIN ((((EA7STUDENTASSIGNMENTS 
INNER JOIN EA7STUDENTS ON EA7STUDENTASSIGNMENTS.EA7STUDENTSID = EA7STUDENTS.EA7STUDENTSID) 
INNER JOIN EA7RECORDS ON EA7STUDENTS.EA7RECORDSID = EA7RECORDS.EA7RECORDSID) 
INNER JOIN EA7CLASSASSIGNMENTS ON EA7STUDENTASSIGNMENTS.EA7CLASSASSIGNMENTSID = EA7CLASSASSIGNMENTS.EA7CLASSASSIGNMENTSID) 
INNER JOIN (EA7COURSES INNER JOIN EA7CLASSES ON EA7COURSES.EA7COURSESID = EA7CLASSES.EA7COURSESID) ON 
EA7CLASSASSIGNMENTS.EA7CLASSESID = EA7CLASSES.EA7CLASSESID) ON EA7SESSIONS.EA7SESSIONSID = EA7CLASSES.EA7SESSIONSID) 
INNER JOIN EA7ACADEMICYEARS ON EA7SESSIONS.EA7ACADEMICYEARSID = EA7ACADEMICYEARS.EA7ACADEMICYEARSID) 
INNER JOIN EA7MARKINGCOLUMNS ON EA7STUDENTASSIGNMENTS.EA7MARKINGCOLUMNSID = EA7MARKINGCOLUMNS.EA7MARKINGCOLUMNSID) 
INNER JOIN TABLEENTRIES ON EA7MARKINGCOLUMNS.DESCRIPTION = TABLEENTRIES.TABLEENTRIESID
ORDER BY
EA7RECORDS.LASTNAME, EA7COURSES.COURSENAME


Microsoft Access Query:

SELECT
dbo_EA7RECORDS.LASTNAME, dbo_EA7COURSES.COURSENAME, dbo_EA7ACADEMICYEARS.DESCRIPTION AS Year, dbo_TABLEENTRIES.DESCRIPTION AS [Marking Column], dbo_EA7CLASSASSIGNMENTS.NAME AS Assignment, dbo_EA7STUDENTASSIGNMENTS.GRADE, dbo_EA7CLASSASSIGNMENTS.MAXPOINTS, dbo_EA7STUDENTASSIGNMENTS.COMMENTS

FROM
(((dbo_EA7SESSIONS INNER JOIN ((((dbo_EA7STUDENTASSIGNMENTS INNER JOIN dbo_EA7STUDENTS ON dbo_EA7STUDENTASSIGNMENTS.EA7STUDENTSID = dbo_EA7STUDENTS.EA7STUDENTSID) INNER JOIN dbo_EA7RECORDS ON dbo_EA7STUDENTS.EA7RECORDSID = dbo_EA7RECORDS.EA7RECORDSID) INNER JOIN dbo_EA7CLASSASSIGNMENTS ON dbo_EA7STUDENTASSIGNMENTS.EA7CLASSASSIGNMENTSID = dbo_EA7CLASSASSIGNMENTS.EA7CLASSASSIGNMENTSID) INNER JOIN (dbo_EA7COURSES INNER JOIN dbo_EA7CLASSES ON dbo_EA7COURSES.EA7COURSESID = dbo_EA7CLASSES.EA7COURSESID) ON dbo_EA7CLASSASSIGNMENTS.EA7CLASSESID = dbo_EA7CLASSES.EA7CLASSESID) ON dbo_EA7SESSIONS.EA7SESSIONSID = dbo_EA7CLASSES.EA7SESSIONSID) INNER JOIN dbo_EA7ACADEMICYEARS ON dbo_EA7SESSIONS.EA7ACADEMICYEARSID = dbo_EA7ACADEMICYEARS.EA7ACADEMICYEARSID) INNER JOIN dbo_EA7MARKINGCOLUMNS ON dbo_EA7STUDENTASSIGNMENTS.EA7MARKINGCOLUMNSID = dbo_EA7MARKINGCOLUMNS.EA7MARKINGCOLUMNSID) INNER JOIN dbo_TABLEENTRIES ON dbo_EA7MARKINGCOLUMNS.DESCRIPTION = dbo_TABLEENTRIES.TABLEENTRIESID

ORDER BY
dbo_EA7RECORDS.LASTNAME, dbo_EA7COURSES.COURSENAME;

Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Our Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.