Kathy,
It was not clear from your last message whether you had the answer you needed.
I will expand on LJ's comments.
QBE Anywhere applies to the QBE section of the screen. That is the field
layout section or the "Query by
Example" area. The Advanced Search bar is exactly that an advanced ADDITIONAL
search to any criteria
specified in the QBE area. There are no options or qualifications there. You
must enter exactly what you
want to do in the Advanced search bar.
If you want to find something with a partial match, you must use the LIKE
operator (that is done for you
automatically in the QBE section).
So, your search would be
'Record Number' LIKE "%1234"
The LIKE operator indicates you are doing a pattern match vs. an = which is an
exact match. When using LIKE,
you use wildcard characters to specify the pattern you want.
'a' LIKE "1234"
no wildcards so it is equivalent to 'a' = "1234"
'a' LIKE "%1234"
wildcard of % means match any 0 or more characters so anything ENDING in
1234 would be found
'a' LIKE "%1234%"
wildcard of % at start and end means match anything having 1234 anywhere
in the value
You need to use the right syntax in the Advanced query bar to accomplish what
you are looking for.
Now, if you have QBE set to Anywhere, you could have just put 1234 in the
Record Number field up in the
screen area and it would have found the right match for you.
I hope this helps,
Doug Mueller
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Wednesday, September 10, 2014 8:36 AM
To: arslist@ARSLIST.ORG
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.
_ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
