Wild cards

D

Denis

I am looking for more information in passing information between a form and using "like *

The query would read something like this

Like forms![formname]![controlname] *
 
F

fredg

I am looking for more information in passing information between a form and using "like *"

The query would read something like this:

Like forms![formname]![controlname] *
Click to expand...

If the data in [ControlName] was "Smith" then to get all records that
include "Smith" any where in the field, i.e. Smith, Smithtown,
Hammersmith, use:
Like "*" & forms![formname]![controlname] & "*"

To return only records that begin with Smith, use:
Like "*" & forms![formname]![controlname]

To return records that only end in Smith, use:
Like forms![formname]![controlname] & "*"
 
D

Denis

Thank

----- fredg wrote: ----

On Wed, 14 Apr 2004 17:01:02 -0700, Denis wrote
I am looking for more information in passing information between a form and using "like *
The query would read something like this
Like forms![formname]![controlname]
Click to expand...
Click to expand...

If the data in [ControlName] was "Smith" then to get all records tha
include "Smith" any where in the field, i.e. Smith, Smithtown
Hammersmith, use
Like "*" & forms![formname]![controlname] & "*

To return only records that begin with Smith, use
Like "*" & forms![formname]![controlname]

To return records that only end in Smith, use
Like forms![formname]![controlname] & "*
 
Top