"LIKE" Query from a form

[FredPeters]

I have a form to receive data(eg car) to use as search criteria for any part of the field. eg. Like *car* to return cargo, transcar, miscarriage etc.

I need to find numbers, letters, etc in the same field. Caps is not an issue.

It is not returning any results.

Help

Fred

 

[Transcend]

Hi

can you paste your query?

Transcend

 

[FredPeters]

First, thanks for answering.
Second, sorry Trancend, I dont understand what you mean by pasting a query.

Fred

 

[MazeWorX]

open your query in design view

goto views and select SQL

Copy the text and paste it to your post

(-: Remember amateurs built the ark - professionals built the Titanic

 

[FredPeters]

AAAHHHHH I get it now....I thought that was the solution. Heres the inoperative query. I've tried moving the astericks around to no avail.

SELECT [2002 Membership].NAME, [2002 Membership].SURNAME, [2002 Membership].ID
FROM [2002 Membership] INNER JOIN [2002 Membership] AS [2002 Membership_1] ON [2002 Membership].ID = [2002 Membership_1].ID
WHERE ((([2002 Membership].SURNAME) Like "* [Forms]![fnamesearch]![txtname]*&quot);

Thanks All!

Fred
ps. does everybody type there wise saying every post or is there a quick way to enter.

And in the end, The love you get,
Is equal to the love you give.

 

[MazeWorX]

You can use the % sign in a Like Expression. When used in a LIKE expression % is a wild card

eg. LIKE 'Back%';>> returns all occurrences that started with back

LIKE '%Back%';>> return any occurrence in the column


You should note that references to data are always case sensitive. One way around this would be to format all of the names in your table so that they begin with a captial Remember amateurs built the ark - professionals built the Titanic

 

[PaulBricker]

Fred when you add it to the criteria line for a query, you need to use this syntax

Like "*" & Forms!fnamesearch!txtname & "*"

As for the wise saying, I think you go to your personal profile and put it in a signiture box there. I don't know any wise saying so I don't use it.

Paul

 

[FredPeters]

Thanks ALL for responding. MazeWorx, I tried yours in different variations to no avail. Paul..yours worked nicely. Again...Thanks ALL!!

Fred

ps. it's nice to know help is out here!
Happy Holidays

 

[MazeWorX]

The diff. between SQL and the SQL(Jet) used in Access Remember amateurs built the ark - professionals built the Titanic