Select WHERE DATE is within 6 months, AND redrillMasterID = "" or Null

Take that recordset (x) and use for the following:

Select distinct Individual from x (I).

For each Individual in I

	Select from x where Individual = Individual (y)

		Select distinct Category from y (z)
	
		For each category in z

			Select WHERE Category = Category (c)
			
				Select from c Where Bold = "Failed" (f)
				Count number of records in f
				If number of records > 1 Then
					For each record Store date, category, individual as variable
	
					
				Select from c Where Percent < .8 (p)
				Count number of records in p
				If number of records > 1 Then
					For each record Store date, category, individual as variable

			Next category
	Next Individual