I have attached a sample data sheet in Excel so you can see what the data is doing. Also have attached in Word pictures of the design view so you can see how I imputed the parameters for the query. Below is the SQL code.
I am wanting to pull data for specific students about courses taken in a particular year and term with certain prefixes. What I am getting is duplication between every term needed. The sample student attached has taken 8 courses at one or two per term. I am needing Access to pull out the particular term and year that a student enrolled in a specific course. Also, the data only shows one specialization and one degree and so I also need it show all specializations and degrees for the student. Thanks Jennifer
ELECT DISTINCT dbo_ACADEMIC.PEOPLE_ID, dbo_PEOPLE.LAST_NAME, dbo_PEOPLE.FIRST_NAME, dbo_ACADEMIC.DEGREE, dbo_CODE_CURRICULUM.LONG_DESC, dbo_ACADEMIC.ACADEMIC_TERM, dbo_ACADEMIC.ACADEMIC_YEAR, dbo_TRANSCRIPTDETAIL.EVENT_ID, dbo_TRANSCRIPTDETAIL.SECTION, dbo_ACADEMIC.COLLEGE, dbo_USERDEFINEDIND.PRIMARYCAMPUS, dbo_ACADEMIC.PROGRAM, dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT
FROM dbo_SECTIONS, (dbo_ADDRESSSCHEDULE INNER JOIN (((dbo_ACADEMIC INNER JOIN dbo_CODE_CURRICULUM ON dbo_ACADEMIC.CURRICULUM = dbo_CODE_CURRICULUM.CODE_VALUE_KEY) INNER JOIN dbo_PEOPLE ON dbo_ACADEMIC.PEOPLE_ID = dbo_PEOPLE.PEOPLE_ID) INNER JOIN dbo_USERDEFINEDIND ON dbo_PEOPLE.PEOPLE_ID = dbo_USERDEFINEDIND.PEOPLE_ID) ON dbo_ADDRESSSCHEDULE.PEOPLE_ORG_CODE_ID = dbo_ACADEMIC.PEOPLE_CODE_ID) INNER JOIN dbo_TRANSCRIPTDETAIL ON dbo_PEOPLE.PEOPLE_CODE_ID = dbo_TRANSCRIPTDETAIL.PEOPLE_CODE_ID
WHERE (((dbo_ACADEMIC.ACADEMIC_YEAR) Like "2016" Or (dbo_ACADEMIC.ACADEMIC_YEAR) Like "2017") AND ((dbo_TRANSCRIPTDETAIL.EVENT_ID) Like "BUAD5*") AND ((dbo_TRANSCRIPTDETAIL.SECTION) Like "LU*" Or (dbo_TRANSCRIPTDETAIL.SECTION) Like "VC*") AND ((dbo_ACADEMIC.COLLEGE)="BUAD") AND ((dbo_USERDEFINEDIND.PRIMARYCAMPUS)="O000000014") AND ((dbo_ACADEMIC.PROGRAM)="GRADEX") AND ((dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT) Like "A" Or (dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT)="D") AND ((dbo_ACADEMIC.PRIMARY_FLAG)="Y")) OR (((dbo_ACADEMIC.ACADEMIC_YEAR) Like "2016" Or (dbo_ACADEMIC.ACADEMIC_YEAR) Like "2017") AND ((dbo_TRANSCRIPTDETAIL.EVENT_ID) Like "ECON5*") AND ((dbo_TRANSCRIPTDETAIL.SECTION) Like "LU*" Or (dbo_TRANSCRIPTDETAIL.SECTION) Like "VC*") AND ((dbo_ACADEMIC.COLLEGE)="BUAD") AND ((dbo_USERDEFINEDIND.PRIMARYCAMPUS)="O000000014") AND ((dbo_ACADEMIC.PROGRAM)="GRADEX") AND ((dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT) Like "A" Or (dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT)="D")) OR (((dbo_ACADEMIC.ACADEMIC_YEAR) Like "2016" Or (dbo_ACADEMIC.ACADEMIC_YEAR) Like "2017") AND ((dbo_TRANSCRIPTDETAIL.EVENT_ID) Like "FINA5*") AND ((dbo_TRANSCRIPTDETAIL.SECTION) Like "LU*" Or (dbo_TRANSCRIPTDETAIL.SECTION) Like "VC*") AND ((dbo_ACADEMIC.COLLEGE)="BUAD") AND ((dbo_USERDEFINEDIND.PRIMARYCAMPUS)="O000000014") AND ((dbo_ACADEMIC.PROGRAM)="GRADEX") AND ((dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT) Like "A" Or (dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT)="D")) OR (((dbo_ACADEMIC.ACADEMIC_YEAR) Like "2016" Or (dbo_ACADEMIC.ACADEMIC_YEAR) Like "2017") AND ((dbo_TRANSCRIPTDETAIL.EVENT_ID) Like "MGMT5*") AND ((dbo_TRANSCRIPTDETAIL.SECTION) Like "LU*" Or (dbo_TRANSCRIPTDETAIL.SECTION) Like "VC*") AND ((dbo_ACADEMIC.COLLEGE)="BUAD") AND ((dbo_USERDEFINEDIND.PRIMARYCAMPUS)="O000000014") AND ((dbo_ACADEMIC.PROGRAM)="GRADEX") AND ((dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT) Like "A" Or (dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT)="D")) OR (((dbo_ACADEMIC.ACADEMIC_YEAR) Like "2016" Or (dbo_ACADEMIC.ACADEMIC_YEAR) Like "2017") AND ((dbo_TRANSCRIPTDETAIL.EVENT_ID) Like "MISM5*") AND ((dbo_TRANSCRIPTDETAIL.SECTION) Like "LU*" Or (dbo_TRANSCRIPTDETAIL.SECTION) Like "VC*") AND ((dbo_ACADEMIC.COLLEGE)="BUAD") AND ((dbo_USERDEFINEDIND.PRIMARYCAMPUS)="O000000014") AND ((dbo_ACADEMIC.PROGRAM)="GRADEX") AND ((dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT) Like "A" Or (dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT)="D")) OR (((dbo_ACADEMIC.ACADEMIC_YEAR) Like "2016" Or (dbo_ACADEMIC.ACADEMIC_YEAR) Like "2017") AND ((dbo_TRANSCRIPTDETAIL.EVENT_ID) Like "MKTG5*") AND ((dbo_TRANSCRIPTDETAIL.SECTION) Like "LU*" Or (dbo_TRANSCRIPTDETAIL.SECTION) Like "VC*") AND ((dbo_ACADEMIC.COLLEGE)="BUAD") AND ((dbo_USERDEFINEDIND.PRIMARYCAMPUS)="O000000014") AND ((dbo_ACADEMIC.PROGRAM)="GRADEX") AND ((dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT) Like "A" Or (dbo_TRANSCRIPTDETAIL.ADD_DROP_WAIT)="D"))
ORDER BY dbo_PEOPLE.LAST_NAME, dbo_PEOPLE.FIRST_NAME;