Search - trouble with "Like"

[Montez659]

I am having a hard time understanding what I am doing wrong with this search string (this is in a query). Here it is:

Like [Tasks].[Tax ID] Or Like [Tasks].[Description]

I have also tried

Like "*" & [Tasks].[Description] & "*" Or Like [Tasks].[Tax ID]

The first one does not return what I need and the second returns more than I need. The problem seems to lie in the [Tasks].[Description] field, which is a memo field. The Tax ID field is a text field and it seems to be returning what it is supposed to.

Thanks in advance for the help!

 

[Norie]

Can you tell us what your searching for?

 

[Montez659]

My bad, I forgot to include everything. Here is the SQL:

SELECT Tasks.ID, Tasks.Title, Tasks.[Start Date], Tasks.[Assigned To], Tasks.[Tax ID]
FROM Tasks
WHERE ((([Forms]![frmRequests]![reqTax]) Like [Tasks].[Description] Or ([Forms]![frmRequests]![reqTax]) Like [Tasks].[Tax ID]));

Basically, in the O n Current Event of the frmRequests, I want to fill a listbox with possible matches to what is entered in the frmRequests Tax ID box (reqTax). This can be in two possible places - Tasks.Tax ID or Tasks.Description. It seems that the first string of code that I posted is returning matches in the Tax ID field, but the Description field is giving me problems.

Oh, and they are text, but the description field is memo.

Hope this is enough info for ya!

 

[Montez659]

Hmmm, I think I may have reversed the variable and field in the Like statements.

WHERE (((Tasks.[Tax ID]) Like [Forms]![frmRequests]![reqTax])) OR (((Tasks.Description) Like "*" & [Forms]![frmRequests]![reqTax] & "*"));

Yep, that seems to be it. The above works.

 

[Norie]

I always get that sort of thing the wrong way round.

More with InStr though.