I am having a problem making a query that works with a memo datatype. I can use * to pull all of the information, but if I try to search on a keyword in that memo it comes back blank. what am I doing wrong?

Paula

Hi Paula and welcome to the forum!

You can't search on one item in a memo field. You may need to give you user another field (like "Topic") to search on.

HTH,

Loralee

Lorelee,
 Thank you soooo Much for responding. I am severely lost. I am in my 6th week of Access class and this one has me stumped. I have to use the Design View for creating my Query. So I put in 5 of the different fields including the comment field (which is the memo data type I have to use to search with). I took your advice and used the key word to search with under the memo section and then I chose another field and put a keyword that I knew corresponded to the record that should have been pulled up. (so it should have pulled up the trainer with the trainer number of 203 and that had a degree in recreation Management) when I hit the run button it comes back blank.
Am I not following your instructions correctly?
Paula

Set your criteria to:

LIKE '*keyword*'

and it should work.

No, you are NOT following the instructions correctly.

What Loralee is saying is that you can NOT search or use criteria on a MEMO data type fiels.

You will have to create a new field or use a different fiels that is text and then "search" on that field and NOT the memo field.

If you do try to search (use criteria) on a memo field, Access will only use the first 255 characters of the memo field.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Hi Paula,
Hang in there. With only 6 weeks working with Access it sounds like you have covered alot of territory.
What is is that you want to sort on in the memo field? If it is TrainerNumber, then create a separate field called TrainerNumber that you can use to locate the record. You will need that field (a primary key) anyway for other things, like joining to other tables, etc.

HTH, and keep at it!

Loralee

THANK YOU!!

After reading the book again and reading your advice I was able to get it with minimal amounts of beating my head against the wall.
THANK YOU ALL SO MUCH!!!

Paula