Is there a way to have a multifield search with exact AND like criteria? For example, if they search the default autonumber field (primary key - so completely unique), or instead use a different field on the search form that is "like"? I attempted this, but what I found was that once I had one of the multifield criteria to be an exact match, you could no longer get a match/result in the other fields even though they hold a "like" formula. It will now ONLY search for the exact match on the singular field. I'm not sure if that makes sense. I've been looking around the web for answer to no avail!
Hi Richard. Good job. I have a student database, I created a form and linked the form to the query to generate each of the students result based on their names one by one. Note My Database Report Contain Student Details like name, class, sex, dob, scores, psychomotor and cognitive skills, teachers and principals remarks and signature. Pls How can I generate all student in a file at once. One by one searching waste a lot of my time. Thanks
Great video! Looking forward to the whole series!
Go watch em! :)
Awaiting whole series ... ;)
Thank you
NICE VIDEO, I would like to learn VBA , PLEASE ADVISE
Is there a way to have a multifield search with exact AND like criteria? For example, if they search the default autonumber field (primary key - so completely unique), or instead use a different field on the search form that is "like"? I attempted this, but what I found was that once I had one of the multifield criteria to be an exact match, you could no longer get a match/result in the other fields even though they hold a "like" formula. It will now ONLY search for the exact match on the singular field. I'm not sure if that makes sense. I've been looking around the web for answer to no avail!
Hi Richard. Good job. I have a student database, I created a form and linked the form to the query to generate each of the students result based on their names one by one. Note My Database Report Contain Student Details like name, class, sex, dob, scores, psychomotor and cognitive skills, teachers and principals remarks and signature. Pls How can I generate all student in a file at once. One by one searching waste a lot of my time. Thanks
Thanks
You're welcome
Where is part 2? I don't understand why the video stops.
Link in the description.
But wait.! There is more! 😂 Tks
Yep yep