Query finds wrong data.

  • Thread starter Thread starter dbl
  • Start date Start date
D

dbl

Hi I have a query with the following sort criteria

Like [BodyshopName]![txtFindCustomer] & "*"

The problem I have it picks up every company that begins with say "CAR" how
do I narrow it down so that it picks up only one company without putting in
the full company name? Is this possible?

Bob
 
Bob,

This is a selection criterion, not a sort criterion. And, what you are
asking is only possible if you use Totals > First (or Last), but you
will have no control over which company starting CAR will be returned.

HTH,
Nikos
 
or use the TOP word,

ie select top 1 . . . . where somefield Like
[BodyshopName]![txtFindCustomer] & "*"


Nikos Yannacopoulos said:
Bob,

This is a selection criterion, not a sort criterion. And, what you are
asking is only possible if you use Totals > First (or Last), but you will
have no control over which company starting CAR will be returned.

HTH,
Nikos
Hi I have a query with the following sort criteria

Like [BodyshopName]![txtFindCustomer] & "*"

The problem I have it picks up every company that begins with say "CAR"
how do I narrow it down so that it picks up only one company without
putting in the full company name? Is this possible?

Bob
Click to expand...
Click to expand...
 
Back
Top