Select Query Issue

[Hutchy]

I have a table, namely Burnt DVDs (Movies/TV Series).
It has 3 fields of data, namely Title, Release Date and Comment(which has the data type, Memo).

I also have a form, namely Burnt DVDs (Movies/TV Series) Search Who Loaned DVD that is linked to a select query. The query filters the records based on whatever I enter in the form. It filters the Comment field.

This is the code I used in the Criteria field...

[Forms]![Burnt DVDs (Movies/TV Series) Search Who Loaned DVD]![Comment]​

What I want is whenever I enter only a portion of text, it should return the results regardless of wherever the text is in the field.
For example, one of the fields has...
'This is a reboot to the original 'Spider-Man'. Tasha borrowed this.'
Another one of the fields has...
'Tasha borrowed this.'

When I enter 'Tasha', it returns no data.
But when I enter 'Tasha borrowed this.' It returns data for only the fields that have...
'Tasha borrowed this.'

I am aware of the 'LIKE' and '**'. But no matter how I used it, it doesn't work. Probably I'm doing it wrong.

Can someone help, please?

 

[pr2-eugin]

Hutchy can you show us the SQL code you have? Also just a suggestion it is best to avoid Special characters, including Spaces from Form and field names.. Smaller names are also good..

 

[Hutchy]

Can someone please close this?

I found the solution here

http://www.access-programmers.co.uk/forums/showthread.php?t=167682

Sorry about this.

 

[Hutchy]

Hutchy can you show us the SQL code you have? Also just a suggestion it is best to avoid Special characters, including Spaces from Form and field names.. Smaller names are also good..

Thanks for your response, but I found the solution

Change this:

Like '* Forms![New Enquiry]![Property Size] *'

To this:

Like "*" & Forms![New Enquiry]![Property Size] & "*"

JR

 

[pr2-eugin]

Good to hear.. To mark thread as solved..

 

[RainLover]

I did not think this would work on a Memo field.

I must have a closer look.