LJ is correct Advanced search overrides (ignores if you prefer) the QBE property of the field
Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Wednesday, September 10, 2014 10:53 AM To: [email protected] Subject: Re: Search ** Kathy, QBE applies solely to values entered IN the field, so if your QBE is set to Anywhere, that means that you can put 1425 into the field, and it'll do an 'anywhere' search and return any results specified. When you are using the Advanced Search bar, you are specifying your own qualification, so you are saying =, which the request id doesn't =, so no results. if you want to 'replicate' the QBE in the Advanced Search using 1425, you need to specify 'Record Number LIKE "%1425%" From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kathy Morris Sent: Wednesday, September 10, 2014 10:36 AM To: [email protected] Subject: Search ** Hi, There is record in the Form A REC1425. When I Advanced Search in the form : 'Record Number = 1425 (this does not work) 'Record Number = INC1425 (this works, the record appears). The field is set to QBE=Anywhere. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

