simontheak
New Member
- Joined
- Jan 21, 2003
- Messages
- 5
I apologise in advance for what I'm sure is a very simple question ... however I'm a newbie and still learning Access.
I have set up a simple table containing a couple of text fields and a couple of memo fields. I have written a couple of simple queries to search the text fields, however the same formula is not working for the memos. Here's what I have:
Like [Please enter a keyword here]
Unfortunately this means that the database doesn't find anything unless someone types in the exact phrase that is held in the Description field (the field containing the memo). As you can imagine this isn't much good. I'd like the user to type in a word and Access to search for that word in the whole of the memo and then display the record if it finds it.
Does that make sense?
I hope someone might be able to help me .... thanks very much for your help in advance!
I have set up a simple table containing a couple of text fields and a couple of memo fields. I have written a couple of simple queries to search the text fields, however the same formula is not working for the memos. Here's what I have:
Like [Please enter a keyword here]
Unfortunately this means that the database doesn't find anything unless someone types in the exact phrase that is held in the Description field (the field containing the memo). As you can imagine this isn't much good. I'd like the user to type in a word and Access to search for that word in the whole of the memo and then display the record if it finds it.
Does that make sense?
I hope someone might be able to help me .... thanks very much for your help in advance!
