Parameter Value

[dl41001]

Hi,
I would like to have a query where the user can enter a few letters and can pull data containing these letters and related fields...
Ex:
User enters 'west' to pull all data in that field containing 'west' such as 'westland', 'eastwest'...
select * from a_tbl
where b_field like '*[enter parameter value]*'
is not working...
Pls help!
Thank you.

 

[ColinEssex]

You need to type the following into the criteria line of the field:

Like "*" & [Enter value] & "*"

Col

 

[dl41001]

Thanks