Data Type

[minoad]

sqltext = "Select * from Active_Patients Where number=('" & strname & "');"

Real dumb one, the above code is returning a 'Data Type Mismatch Error'. I am attempting to pass a number as a variable. Anyone see the error?

Micah A. Norman

 

[TimLarkin]

sqltext = "Select * from Active_Patients Where number=('" & strname & "');"

should be...

sqltext = "Select * from Active_Patients Where number=(" & strname & ""

 

[TimLarkin]

let's try that again...
sqltext = "Select * from Active_Patients Where number=" & strname & ";"
That assumes strname is a number otherwise(for an integer)

sqltext = "Select * from Active_Patients Where number" & Cint(strname) & ";"

For a long - CLng(strname) etc..