M
Mozy
I'm a complete novice so bear with me. I have been asked to set up an
enquiries database that includes an Enquiry field, Keyword1, Keyword2,
Keyword3 and Keyowrd4 fields (among others). I would have preferred one
keyword field with free text but the boss, you know ...
How do I set up a query across all those 5 fields. e.g. if I wanted to
search for organic fruit but 'organic' is in one field and 'fruit' is in
another? I've been able to set up a search for a single word but not linking
multiple words.
Any help most gratefully received!
enquiries database that includes an Enquiry field, Keyword1, Keyword2,
Keyword3 and Keyowrd4 fields (among others). I would have preferred one
keyword field with free text but the boss, you know ...
How do I set up a query across all those 5 fields. e.g. if I wanted to
search for organic fruit but 'organic' is in one field and 'fruit' is in
another? I've been able to set up a search for a single word but not linking
multiple words.
Any help most gratefully received!