Untitled

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 x

	Select from x where Individual = Individual (y)

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

			Select WHERE Category = Category (c)
			
				Select Where