MS Access (again): Keyword?

They have: 71 posts

Joined: Aug 2001

I know, I know, this is all I seem to ask about but I need another query. This time this one needs to be a keyword search, could any of you guys help me out? or tell me a good tutorial site to use or something?

Thanks,
Adam.

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

Well, that's a pretty broad question. Without knowing the table and field names I can't really give you a sample script.

You'll be using logical operators like:

LIKE
OR
BETWEEN
AND
etc,etc

To see a good example check out:
http://www.asp101.com/samples/viewasp.asp?file=db%5Fsearch%2Easp

PJ | Are we there yet?
pjboettcher.com

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.