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