Solved How to set SQL Query for Text type field

[rehanemis]

Hello,
I have a statement written and getting problem in working when I changed the Field "EmpID" from number to Text.

strSql = "SELECT *, Format(Date(),'yyyy')-Format([DoB],'yyyy') AS Age FROM tblRecallSheetStatus WHERE EmpID=" & emp_no & " ;"
Set qdf = CurrentDb.QueryDefs("qrySearchRecordForReport")
qdf.SQL = strSql

Can anyone suggest the solution?

 

[pbaldy]

Try

strSql = "SELECT *, Format(Date(),'yyyy')-Format([DoB],'yyyy') AS Age FROM tblRecallSheetStatus WHERE EmpID='" & emp_no & "';"

 

[rehanemis]

Worked Perfectly!
Can you assist bit more as you can see in snapshot.

 

[pbaldy]

I don't use macros, but try adding a single quote right before the last double quote, and then this at the end:

& "'"