Hi everyone,
I have a table in my database for recording incoming customer enquiries which contains a field called 'Notes'. Notes is a memo field.
I am trying to create a query that will enable me to search for text data and return any records that contain the text I have entered, I suppose in a similar way to the 'Find/Replace' function, but bringing up a list of records rather than clicking from one to the next using 'Find next' in a form or something.
In design view, I have added three fields from my table to the query (ID, Enquiry Date and Notes) and I have put [Enter search text] in the critiera box under Notes.
However, when I run the query, no records are returned even when I enter the exact text on of the records contains.
I have heard that memo fields can be problematic, so I don't know if anyone else has encountered difficulties when trying to run a query based on this type of field. Furthermore, when I change the field type to text, it works (but I like the fact that a memo query can hold more data so I would like to keep it as this format if possible).
Any help out there?
Thanks a lot.