raymond3090
Registered User.
- Local time
- Today, 23:16
- Joined
- Sep 5, 2002
- Messages
- 43
Hi there,
Nobody was replying to my last question so I thought I'd try to clarify and redefine my problem!
I currently have a search form that uses the user's input into text fields as searching criteria for a query. I've been using the following for my Where statement:
Is Null Or Like "*" & [Forms].[Search].[txtField] & "*"
This is working great for me so far.
I would like to step up the search method a notch my allowing the user to input the AND and OR operators if they desire. I'm pretty sure that is what they do on this site for their search field. However, I have no idea how to do this!
Any help would be greatly appreciated!!
Ray
Nobody was replying to my last question so I thought I'd try to clarify and redefine my problem!
I currently have a search form that uses the user's input into text fields as searching criteria for a query. I've been using the following for my Where statement:
Is Null Or Like "*" & [Forms].[Search].[txtField] & "*"
This is working great for me so far.
I would like to step up the search method a notch my allowing the user to input the AND and OR operators if they desire. I'm pretty sure that is what they do on this site for their search field. However, I have no idea how to do this!
Any help would be greatly appreciated!!
Ray
