Newb Needing Help..

[chook]

Hi All,



I am trying to get a multiple keyword search query working.... the single search is working however when i use the Multiple Keyword search the datasheet does pop up but no matter what i put in i just get a blank table and under ID it says "NEW"

The Keywords Column has a bunch of keywords separated by commas on each row. Sometimes there will be the same keywords on different rows under the keyword column... and i want it to return any rows that have 1 or more of the keywords in it or if it is null just to return them all....... this is the statement I am trying...

SELECT Sea.ID, Sea.Category, Sea.Title, Sea.Author, Sea.Organisation, Sea.Date, Sea.Keywords, Sea.Reference
FROM Sea
WHERE (((InStr([Keywords separated by commas,Blank=All],[Keywords]))>0 Or (InStr([Keywords separated by commas,Blank=All],[Keywords])) Is Null));

Any help would be greatly appreciated and i can provide more info if required!

Thank you.

[chook]

This is access 2007 i am using... would it help if i attached a test file?

[chook]

uploaded.. the "multiple keyword search" is the one i cannot get to work.
For example i want to be able to put into the box: test,rabbit and it will return any record rows that have test and rabbit in any form singularly or together in the same keyword row..

[chook]

Any ideas? im stumped.