Help needed in Criteria Field Please.

[Guest]

Hello every Body.

I am making a DB in Access. I have a Query for Search which takes Parameter
Name form me and search out the
entire record in the table and display it. For that I gave the criteria
LIKE [Enter the name to search:]

Now I want that my query is to search the first three Letters of the Name
that i gave as a parameterand returns me all those names that matches the
Parameters First three words. but i can not do so,I don not know how to
specify this condition in the criteria the criteria.

i don not know format . So can any one help me in these regards please...

Early response is ahigly appreciable.

Thanks,
Khaksar.

 

[Allen Browne]

Add the wild card:
LIKE [Enter the name to search:] & "*"

 

[Guest]

Respected Browne Your idea was Superb. It works really. Now as the query
display my result in table. It will display all the names whcih first three
characters match. Now If i want to search in the Query result again What
should I do. I mean If i want to further purify my result to go to a specifin
record.

For example:- If I give Browne in the search it will show all the records
that contains browne. Now i want to search again in the filtered result for
some specific browne lets suppose i want to searhc in the result by Phone
number. Can you help me please?

Thanks alot.....

Add the wild card:
LIKE [Enter the name to search:] & "*"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hello every Body.

I am making a DB in Access. I have a Query for Search which takes
Parameter
Name form me and search out the
entire record in the table and display it. For that I gave the criteria
LIKE [Enter the name to search:]

Now I want that my query is to search the first three Letters of the Name
that i gave as a parameterand returns me all those names that matches the
Parameters First three words. but i can not do so,I don not know how to
specify this condition in the criteria the criteria.

i don not know format . So can any one help me in these regards please...

Early response is ahigly appreciable.

Thanks,
Khaksar.

 

[Allen Browne]

I think you will need to design a form so you can search on different
fields, and repeat the searches at will.

This does involve writing some VBA code. Here's an example to download and
follow:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Respected Browne Your idea was Superb. It works really. Now as the query
display my result in table. It will display all the names whcih first
three
characters match. Now If i want to search in the Query result again What
should I do. I mean If i want to further purify my result to go to a
specifin
record.

For example:- If I give Browne in the search it will show all the records
that contains browne. Now i want to search again in the filtered result
for
some specific browne lets suppose i want to searhc in the result by Phone
number. Can you help me please?

Thanks alot.....

Add the wild card:
LIKE [Enter the name to search:] & "*"

Hello every Body.

I am making a DB in Access. I have a Query for Search which takes
Parameter
Name form me and search out the
entire record in the table and display it. For that I gave the criteria
LIKE [Enter the name to search:]

Now I want that my query is to search the first three Letters of the
Name
that i gave as a parameterand returns me all those names that matches
the
Parameters First three words. but i can not do so,I don not know how
to
specify this condition in the criteria the criteria.