oxicottin
Learning by pecking away....
- Local time
- Today, 08:10
- Joined
- Jun 26, 2007
- Messages
- 891
Hello, I have a strSQL string in a function and I don't want it to look for certain words. One of my words has an apostrophe and I was wondering how to fix that? Do you enclose the ' with a "'"
Code:
strSQL = strSQL & "WHERE tbl_YearCalendar.EmployeeID = " & empID & " AND tbluAbsenceCodes.AbsenceCode Not In ('PTO','PTO/F','PTO/M','FMLA','F','JD','ML','FLEX','FD/FML','PPL','PC','DL','ELE/PP','ET/PP','EA/PP','EA/C'd') "