I have a query that I want to ask the user for input when it runs. I don't want it to be an exact lookup, but a general one. For example, in the table a number (text field... on purpose), may be 01750, but as long as the person types in 1750, I want all those to come up. I tried messing with the Like Operator, but I can't get it to ask me what I'm looking for when I run it.

Sorry, wasn't paying attention and put this in the wrong category. Should be in the Queries category. Don't know how to move it.