Searching for partial records

  • Thread starter Thread starter Roger Lante
  • Start date Start date
R

Roger Lante

Hi everyone,

I want to create a query using [Customer Name?] where the
customer whilst running the report can enter a partial
name witha wild card (eg: enter joh* instaed of john
smith). Also i want to enter nothing or a wildcard to
retrieve all records.

This is sending me mad!!

Thanks

Roger
 
Have you tried using the LIKE operator as part of your
criteria or WHERE clause? See the help on the Like Operator

Post back if that doesn't help.
 
Hi everyone,

I want to create a query using [Customer Name?] where the
customer whilst running the report can enter a partial
name witha wild card (eg: enter joh* instaed of john
smith). Also i want to enter nothing or a wildcard to
retrieve all records.

This is sending me mad!!

Thanks

Roger

You need LIKE:

LIKE [Customer name?] & "*"

The default = operator does not recognize wildcards; the LIKE operator
does.
 
Thankyou
I knew it was something simple but I had 1 thing wrong

Much appreciate
-----Original Message-----
Hi everyone,

I want to create a query using [Customer Name?] where the
customer whilst running the report can enter a partial
name witha wild card (eg: enter joh* instaed of john
smith). Also i want to enter nothing or a wildcard to
retrieve all records.

This is sending me mad!!

Thanks

Roger

You need LIKE:

LIKE [Customer name?] & "*"

The default = operator does not recognize wildcards; the LIKE operator
does.


.
 
Back
Top