codeing for an advanced search

W

William Ritchie

I was wondering if there is some sort of code for creating an advanced
search
I have made a photo album and at the moment i have listed in the
keywordsFIELD "dad mum billy"
this producces 154 results BUT i really need and combination to find results
ie "mum dad billy"

ok for me as i listed my family by age first ..........But to other members
of my family it's not really any use

Is there a way of ingnoring the whitespace in a search

please please help
 
R

Rick Brandt

William Ritchie said:
I was wondering if there is some sort of code for creating an advanced
search
I have made a photo album and at the moment i have listed in the
keywordsFIELD "dad mum billy"
this producces 154 results BUT i really need and combination to find results
ie "mum dad billy"

ok for me as i listed my family by age first ..........But to other members
of my family it's not really any use

Is there a way of ingnoring the whitespace in a search

You could use...

keywordsFIELD Like "*dad*"
OR keywordsFIELD Like "*mum*"
OR keywordsFIELD Like "*billy*"

You'd be better off though if each keyword was a separate record in a related table.
It's almost never a good idea to store multiple values in a single field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top