Question Locked

Performing a search of my DB in Access using data access pages

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!!

2 replies

by mohayminu

Hi There,

I am kind of stuck in the same situation. Were you able to find a solution for this?

This discussion is closed to new replies.