Parameter Query

[BLR]

In a parameter query, is it possbile to enter a boolean
expression? For example, if I want to search a text field
for "hello" and "yes," in the prompt box, can I enter:

hello AND yes

Is it possible to search for two different words?

Thanks

 

[Dennis Schmidt]

Hi Blr,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

You cannot use operators in a query-by-form expression. Access considers
all that is returned from the control on the form as either text or a
number.

You can build expressions that use operators on the criteria line such as:

Like Forms!Form1!Field1 OR Forms!Form1!Field2

OR

Like "*" & Forms!Form1!Field1 & "*"

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support