Search anywhere in cell

  • Thread starter Thread starter Deborah Mowry
  • Start date Start date
D

Deborah Mowry

I have a cell that contains reference numbers. Most are 1 but some contain
up to 3 entries (it was not created properly a long time ago). However; I
wish to query where there is a particular reference and I only get it IF it
is the first one entered.
Specifically -
Possible entries are in a few records would be:
PO18
PO12, PO14, PO18
PO14
PO02, PO18
PO18, PO09

I queried for *"PO18"* and it would only return the first and last record,
not the second and fourth!
If I wanted a last name containing Donald I would have typed *Donald* and
got MacDonald and Donaldson, therefore I am not understanding what happened
here.
Deborah
 
As criteria for the field:
Like "*PO18*"

A better way is to NOT hard code the criteria.

Like "*" & [Look For] & "*"

You will be prompted to enter the words.
 
I would never have thought to try that - thank you.
Do you have an explanation for why it would not search as a query? Or is
that too hard to explain?

Many thanks
Deborah


Fredg said:
As criteria for the field:
Like "*PO18*"

A better way is to NOT hard code the criteria.

Like "*" & [Look For] & "*"

You will be prompted to enter the words.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Deborah Mowry said:
I have a cell that contains reference numbers. Most are 1 but some contain
up to 3 entries (it was not created properly a long time ago). However; I
wish to query where there is a particular reference and I only get it IF it
is the first one entered.
Specifically -
Possible entries are in a few records would be:
PO18
PO12, PO14, PO18
PO14
PO02, PO18
PO18, PO09

I queried for *"PO18"* and it would only return the first and last record,
not the second and fourth!
If I wanted a last name containing Donald I would have typed *Donald* and
got MacDonald and Donaldson, therefore I am not understanding what happened
here.
Deborah
Click to expand...
Click to expand...
 
Back
Top