Query Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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.
 
Back
Top