I am trying to create a report that shows students with a combination of two codes (notation code and tracking code) in separate fields in a record, but the students I need to show must only have the one record with this combination of codes in the table.  There can be several records with the same notation code in the table but I don't want to see students with multiple occurences of this particular notation codes.

02	FAFSA ERROR! SEE STAFF	07/15/2011
25	FILE COMPLETE DATE	07/15/2011		07/14/2011	NR
28	COUNSELOR REVIEW	07/15/2011		07/14/2011	NR	AA/ LN
32	FTP NEED ANALYSIS	07/15/2011		04/27/2011	NR
A1	Academic Transcript #1	07/14/2011	07/14/2011		RQ	EAST LA COLLEGE
IE	EOPS INDEPENDENT	07/15/2011			NR	INDEPENDENT
M2	FILE FOLDER OUT TO:	07/15/2011			NR
SP	SAP CHECK - FIRST SEMESTER	07/15/2011			RQ
SQ	SAP CHECK - SECOND SEMESTER	07/15/2011			NR

Thanks for responding.

you have to use the group select expert options for something like this

Edited by DBlank - 05 Mar 2012 at 9:09am

use the sigma sign ( the blue E)

select field to summarize as @flag1