Hi all –
I am trying to run a search of my DB through a query using a couple of fields as a front end wild card search.
Ex.
DB Field1: NAME
wild card entry1: FUN
DB Field1: AGE
wild card entry1: 23
SEARCH
I am creating a WHERE statement of [NAME %FUN% AND AGE %23%].
I can’t figure out how to plug this into a query as the WHERE statement. I tried:
MSODSC.RecordsetDefs.Item(“qry”).ServerFilter = stWhere
to no avail…HELP!!
