Changes To The Query Are Visible
SELECT Visits.Date, Visits.TrackingNum, Visits.DrugR, Visits.HIVR, Visits.AIDSR, Visits.HepatitisBR, Visits.ExceptR
WHERE (((Visits.TrackingNum)<>"") AND ((Visits.DrugR)=Yes));
These queries are expressed in a common database query language, SQL … to see the SQL, select the SQL View under the View menu