Hello, everyone, I am using Access 2013 64-bit on Windows 10.
A few years ago, I created a many-to-many database for my movie collection. Now, I need help creating a query, please.
Some of the movie titles have asterisks at the end of them. I did this to designate which movies are duplicates. I know I can create a check box in the form for this, but until I get around to doing that, I am using asterisks.
Now, what I want to do is create a query for every movie whose title contains an asterisk. Of course, it didn't occur to me until just now that an asterisk serves as a wild card in query searches. As a result, putting: like "*" doesn't work.
So, could anyone please tell me how to set up the query criteria so the query will recognize the asterisk as an actual item to search for, and not a wild card?
The table I am working with is called tblMovies, and the field in question is called Title.
If you need more information, please let me know. Thank you. T. Hulot