movie database

Alan,
Thanks for that, I have had a look at the database you attached and run some test searches however it is still returning the same incorrect search results as my original search criteria:
* When searching by volume it returns all results.
* When searching by title it returns the results that match the search string but also returns any empty rows as well.
* When searching by rating it also returns the relevant results PLUS any empty rows as well.


If you run some test searches on the last database that I attached I hope that you will find - as I did - that the search problems have been resolved.
All of my searches are now returning correct results.