I have the following working in a listbox's rowsource, I would like to modify to a DCount.
SELECT Count(*) AS CountOfDOS FROM TPatient LEFT JOIN TClaim ON TPatient.ID=TClaim.ID WHERE TPatient.ID=Forms!FPatientEntryQuery!ID And TClaim.ActiveClaim=True And [DOS]<DateAdd("d",-60,Date());
I am having issues with the quotes. Can a Dcount be performed as this? If so what would the proper syntax be?