Help with query to seperate year / term

[tjones]

I have a field, Grad Term, that is set up with the Year/Semester: 201330 (spring), 201350 (summer), and 201370 Fall

I have a query that pulls the information i need into a report (student, total etc) by term
SELECT tblStudentInformation.[790ID], [LastName] & ", " & [FirstName] AS Name, tblStudentInformation.DegreeType, tblStudentInformation.Status, tblStudentInformation.CPHGraduateTerm
FROM tblStudentInformation
WHERE (((tblStudentInformation.DegreeType)="CPH") AND ((tblStudentInformation.Status)="Graduated"));

Is it possible to make a query that will take the year "2013" and add the three terms together under the year?

 

[jdraw]

You could try this (untested)

SELECT tblStudentInformation.[790ID]
, [LastName] & ", " & [FirstName] AS Name
, tblStudentInformation.DegreeType
, tblStudentInformation.Status
, tblStudentInformation.CPHGraduateTerm
, [Year/Semester] as Year
FROM tblStudentInformation
WHERE 
tblStudentInformation.DegreeType="CPH" AND 
tblStudentInformation.Status)="Graduated"  AND
[Year] Like "2013*";

But I'm really not sure what you expected with

and add the three terms together under the year?

 

[tjones]

Solved it by going into the reports "Group/Sort/Total"
Group on "GradTerm" and then "by entire value" set to only count the first four.