Just noticed - did you know you have qryClinic & qryClinic in your FROM clause?