Parameter Query

  • Thread starter Thread starter BLR
  • Start date Start date
B

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
 
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
 
Back
Top