like [parameter]*

[knowzero]

I would like to have a parameter in my query but it uses the like on
the parameter. If I want to select ABCD and ABCC and ABCE I will insert
in the parametr field ABC and it will use a sql statment
like "ABC*"

 

[Rick Brandt]

I would like to have a parameter in my query but it uses the like on
the parameter. If I want to select ABCD and ABCC and ABCE I will insert
in the parametr field ABC and it will use a sql statment
like "ABC*"

Like [Enter Parameter] & "*"

 

[David F Cox]

LIKE [enter parameter] & "*"

 

[knowzero]

Thanx for your help