gmatriix
11-05-2007, 05:11 AM
Hello All,
I have a form that I want to search Criteria that is "Like" the data entered. So if I am looking for "VA11336", the user may enter "11336" it will pull that record up (VA11336) and any other records that are "Like" what is entered. Possibly with a "find next" to browse other records. I am not sure how to make the query do this......I tried
Like [Which Site #?] in the query but I know this is not right...
Any Ideas?
Thanks
I have a form that I want to search Criteria that is "Like" the data entered. So if I am looking for "VA11336", the user may enter "11336" it will pull that record up (VA11336) and any other records that are "Like" what is entered. Possibly with a "find next" to browse other records. I am not sure how to make the query do this......I tried
Like [Which Site #?] in the query but I know this is not right...
Any Ideas?
Thanks