Like"*" & (Enter Description)
Like (Enter Description) & "*"
seem like invalid invalid string concatenations, because (Enter description) isn't a string.
Moreover it's quite unclear what you want to do. Parameters are treated as a field, so they in the query they become part of the field list in the select, the like becomes part of the where clause.
I've been having occasional problems with queries that use the "Like" operator in Access 2010. For example, when I use the query builder and type: Like"*" 7 (Enter Description) as my criteria, everything works just fine for a while. However, once I've been using the database for several days, it makes a sudden change. When I run the query, I'll get not one dialogue box that asks me to enter my description, but two. If I clear the paraeters of the query, save it, and then reenter those same parameters, the problem stops, for a short time, but over time, it happens again and again. I need the "*" operator before and after the parameter as those using the data base usually don't know that they can include it. Is there a fix for this problem? A patch that can be downloaded? Or a better way of writing the query? I've tried Like (Enter Description) & "*" but had the same problem. Thank you, in advance for your help and asssistance.