Front Page MS access Search Interface issue

[defosset]

when i have my querys search they need the whole string of information how can i get it to where all they need is partial information and they can search and return data, right now when you search using partial it returns nothing but if your specific it will return answer, i just set up ASP search pages and it only searces baised on specific not partial information, what setting do i need to change in front page or what asp code to i need to add to my page to make it searchable with partial data.

ie album name search: Passion - Hymns Ancient & modern

it will pull up

but if you do: Hymns Ancient & Modern it pulls nothing
nothing