Posted on 2009-05-17
I have a routine to generate a list of unique diagnoses from some health records, but I need to remove the question marks
Sql = ""
Sql = Sql & "Insert into Distinct_Diagnoses [Desc] "
Sql = Sql & " select distinct [Diagnosis] from PATIENT_PROBLEMS "
is giving me
The following change to the SQL gives a "type mismatch" error
Sql = Sql & "select distinct '" & (Replace [Diagnosis] , [?], "" ) & "'"
Any other way of doing the necessary "replace''?