for (AggregateResult r : [ SELECT Field3 FROM Table
WHERE Field1= :strModality
AND Field2= ‘Active’
GROUP BY Field3 ORDER BY Field3 ]) {

}

Groupの合計関数利用して、Field3　Distanct可能になる