set three criteria on one field

[swaink]

Hi everyone I'm not so hot with this one and have been struggling for several hours to get query right.

I'm using Access 97 and have a small DB from which the user wishes to retreive data based on one particular field.

I have created a form based on the query and that works fine however the query is a problem.

The field being searched on is a general comments field and they wish to search for three critera for example *Transport or *National or * Coastal

The idea being that any data where all three are present will be displayed.

I've tried using like [] or like [] or like[] but this doesn't appear to work.

Does anyone have any suggestions as to where I'm going wrong please.

Best regards

Kevin

 

[Russell Hauf]

One question first: Do you want "any data where all three are present will be displayed," like you said in your original post, or do you want data where any of the three will be present? I'm confused, because unless you have a rather large field, I'd guess that only one of the three will be in one field...

Thank you,

Russell

 

[swaink]

Hi Russell

Thanks for your response, the field being searched is up to 255 charaters in length and the users enter comments on current projects.

The user may wish to search and retrieve files that contain transport but this will bring back every file with transport in it, therefore they would prefer to search for "Transport" and "Coastal" for example to get only those files that contain both words the third criteria may be "study".

So again as an example they may wish to view files where the project is regarding transport, in coastal areas, where a study has been under taken.

I hope that hasn't confussed you even more

Kevin

 

[Russell Hauf]

Ok, then try something like:

[fldProj] Like "*Transport*" And [fldProj] Like "*Coast*" And [fldProj] Like "*study*"

HTH,

Russell

 

[swaink]

Hi Russell

Thanks for your help that did the trick

I appreciate your time

Best regards

Kevin