Thread: Use of LIKE operator in a query asking for an input

I'm new to Access and I'm working with queries.
What I'm trying to do is a query which asks for a criteria when run (i.e. using "[]") for a field type "string": using the "LIKE" operator, it would be possible to input only the first "n" characters, obtaining all the records in which the searched field starts with those "n" characters.

To be clearer: searching a field CustomerID, containing "Romoluzzi" and "Romoli", I want that my query asks me "Customer?" and after my input of "Romo", I get both the records with Romoluzzi and Romoli.
The query is unique, the criteria LIKE must be in the "[]", because it can be different at every run ("Romo" is not fixed).

I thank in advance everyone helping me.

In your criteria type:

Like [Enter the first couple of letters of your parameter here] & "*"
Good Luck
Alan