Hey guys,
Does anyone know what is wrong with the following wildcard query?
The wildcard "*" doesn't work and the Patient field has to be exactly the same for the query to find the Patient ID. I tried with and without the concatenation and neither work.Code:SELECT PatientList.[Patient ID], PatientList.Patient FROM PatientList WHERE (((PatientList.Patient) Like "*" & [Treated]![Patient] & "*"));