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.
Bookmarks