Using "Like" expression in Parameter Query (Query Tool)

[Tom Nichol]

I am trying to use the "Like" expression in a Parameter Query.
The correct syntax for this in MS Access is ' Like [user input] & "*" '
When I use this structure in MS Query however (substituting '%' as the wildcard),
I get the error message "too few parameters"
As usual, the online help isn't much
I would be most grateful if someone could provide some assistance here
Many Thank

 

[Paul Falla]

Dear Tom

I don't know if this will work at all, but I do know that
MS query uses single quote marks rather than double - So
you may want to revise your statement to Like [user input]
& '%'

Good luck

Paul Falla

-----Original Message-----
I am trying to use the "Like" expression in a Parameter Query.
The correct syntax for this in MS Access is ' Like [user input] & "*" '.
When I use this structure in MS Query however

(substituting '%' as the wildcard),