Ahhhhh - Why doesn't my Query work!!!

[IAIN]

Basically my problem is that the query for finding books by title:

Like "*" & [Enter Title] & "*"

Only brings back one title...Why is that?

 

[raindrop3]

Hello,

Try this:

"SELECT * FROM [tblNaam] WHERE [name] LIKE ""*" & Trim$([Txtz]) & "*"""

In the field where you enter the search-string, you had to type also the '*'. So:

Opcen*

Hope this help.

Albert

 

[saintsman]

How many books have the same title? I think your query is working fine but whatever you are typing in for [Enter Title] is too restricting. If you enter something like 'book' you would get lots of records but if you entered 'Access Book' then you would probably only get one record for example.