Specifying Criteria on Queries in Microsoft Access 2007?

Question

I'm trying to create a query that will allow my parents to specifically find select songs. When I put the song name however into the criteria box for songs, nothing shows up. And for some reason, it's making me type everything needed to have it show up. ( For EX: I have more than one song listed in the column, and I have to type every song in the criteria box for it to show up) My question is, is how do you get criteria to specify certain characters/ parts of a word? Sorry if this is confusing, but it is confusing :D 10 points to whoever can help.

Answer 1

The wildcard characters either * or ? will be the trick here to find similar string matches. To get a better understanding, take a look at this link http://www.about-access-databases.com/query-criteria.html



It gives plenty of examples covering the string match that you are after.

Answer 2

hi, you could favor to make sparkling somewhat. Which of those sounds extra like your problem: a million) the style's record source is a table, and the precedence is that you're unable to CREATE a clean record utilizing the style except you enter files into each and every of the style fields. 2) the style's record source is a question that retrieves files from a table (or tables), and the precedence is that the question isn't getting each and every of the files that you favor -- so as that once you open the style no longer each and every of the files are there.

Answer 3

You need to use wildcards and the Like operator. For example, if you were looking for any song with the word 'pretty' in it, you'd use the criteria:

Like "*pretty*"



There are many other ways to use wildcards here:

http://office.microsoft.com/en-us/access-help/access-wildcard-character-reference-HA010076601.aspx