thaonguyen
Registered User.
- Local time
- Yesterday, 22:59
- Joined
- Sep 20, 2013
- Messages
- 23
Hi all,
I built a database to store and help searching for lessons/books based on certain criteria. I have a search text box that can search either one of the five fields and a few combo/ list boxes (Thanks to John Big Booty's dynamic search). It works great. However, I want to add a second text box to search more fields at the same time. So ideally, the first text box searches either Title or Work title. and the second text box searches either Vocab, Language points or activities. This is where it stumped me. I tried to write the SQL but I wasn't sure about the OR and AND criteria. So I hope anyone can point me to the right direction. I couldn't attach the whole database because it's much bigger than 2MB. I attached the pic of the search tool to give you a better idea of what I meant.
Thank you!
I built a database to store and help searching for lessons/books based on certain criteria. I have a search text box that can search either one of the five fields and a few combo/ list boxes (Thanks to John Big Booty's dynamic search). It works great. However, I want to add a second text box to search more fields at the same time. So ideally, the first text box searches either Title or Work title. and the second text box searches either Vocab, Language points or activities. This is where it stumped me. I tried to write the SQL but I wasn't sure about the OR and AND criteria. So I hope anyone can point me to the right direction. I couldn't attach the whole database because it's much bigger than 2MB. I attached the pic of the search tool to give you a better idea of what I meant.
Thank you!
Attachments
Last edited:
