Query as a search function

[Mashieman9]

It seems to me that using a query as a search function in Access (97) is a great idea. So far Access has yet to agree with me. I've been trying to figure out how to put in a word that will prompt me to enter a value. But of course when I put a word inbetween the quotations (because I want a specific field to be 'like' a given word) of course is just goes for whatever I type in. Any suggestions, other than just to use the Access search feature? Thanks

--
N.Hunt

 

[lespaul]

Why don't you just write a query that uses like and prompts for a parameter? Doesn't that do what you're asking for?

 

[Tranman]

N.Hunt,
If you want to have a query that asks you for input, then uses your input with the like operator, just use this form:

SELECT CUST.*
FROM CUST
WHERE (((CUST.L_NAME) Like [enter name] & "*&quot);

The criteria line of this query in design view is:
Like [enter name] & "*"

Of course, if you want to mask both sides, you could say:
Like "*" & [enter value] & "*"

That's the same thing lespaul said, but I thought you might be curious about how to deal with the asterisk(s).

Tranman