Hello All
I have been to the moon and back trying to figurer this one out; I have a form, with an Option group that a user can use to filter their data. Upon using a case statement the code looks like this
Case 1
strFilterSQL = strSQL & " Where [Device Name] = 'PE';"
Case 2
strFilterSQL = strSQL & " Where [Device Name] = 'CS';"
This works however the returned values is a record that has the [Device Name] value of ONLY PE value. I want it to return all records that begin with the letters PE. Similiar to a "LIKE" statement in SQL, but i keep getting errors in VB when i type things like : LIKE [Device Name] = 'PE%' ??????????
HTH
Thanks