Query Criteria

T

tkosel

If I have missed the answer to this in an existing post, I apologize.
Nothing matched.

I have Query Criteria for a customer field that is:

Like "*HOEFT*"

It returns 'HOEFT STOCK, HOEFT SHOWROOM, HOEFT STOCK USED and HOEFT-RETURN'.

It does NOT return 'USED HOEFT STOCK'.

Any ideas?
 
J

Jerry Whittle

Strange. The first thing that I would try would be to go to the record in
question and make sure that the O isn't really a zero. Happens quite a bit as
they are close on the keyboard.

Next I'd do a compact and repair just in case there is a corruption issue.

If there is an index on that field, I'd remove the index then recreate it.
The index could be corrupt.

Are you looking lookup fields at table level on that field? It could be that.
 
T

tkosel

Jerry,

I apologize for wasting your time. Shortly after I posted, I realized there
was another limiting Date criteria I had neglected to consider. OOPS.
Thanks for your suggestions and sorry about the lack of concentration.
 
J

Jerry Whittle

No problem. I'm well acquainted with "OOPS" and the occasional "OH $(!%" also.
 
Top