sladewilson
Programmer
I can't seem to get this to work right... I am certain that my syntax is not correct but I don't know where to find examples.
This works like a champ (but shows all records):
objRst.Open "Select * FROM Products " & where
I want to filter out all records marked as deleted.
The field in the database is named "deleted" and the value in the field is "yes" (without the quotes of course).
This will not work:
objRst.Open "Select * FROM Products " & where & "AND deleted <> yes"
Any ideas how I can write the statement to show records that are not marked as deleted?
This works like a champ (but shows all records):
objRst.Open "Select * FROM Products " & where
I want to filter out all records marked as deleted.
The field in the database is named "deleted" and the value in the field is "yes" (without the quotes of course).
This will not work:
objRst.Open "Select * FROM Products " & where & "AND deleted <> yes"
Any ideas how I can write the statement to show records that are not marked as deleted?