codeing for an advanced search

  • Thread starter Thread starter William Ritchie
  • Start date Start date
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
 
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
Click to expand...

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.
 
Back
Top