Search a record similar to LIKE function?

[kathnicole]

Hi All,

I would like to retreive all the records that starts, where the field CompanyName in table tblJob start with "sap*"... i assume this can be acheived by using LIKE function in query design but i want the user to enter the text.

Say, there are two company Names like "sapin" and "sapeen"

when the user enters the text as "sap", it should list all the records where the company name starts with Sap..

and again, if the user enters, "ABC", i want access to list all records where the company name starts with ABC.

Any help in this regard.

thanks,
Kathy

[kepston]

Hi All,

I would like to retreive all the records that starts, where the field CompanyName in table tblJob start with "sap*"... i assume this can be acheived by using LIKE function in query design but i want the user to enter the text.

Say, there are two company Names like "sapin" and "sapeen"

when the user enters the text as "sap", it should list all the records where the company name starts with Sap..

and again, if the user enters, "ABC", i want access to list all records where the company name starts with ABC.

Any help in this regard.

thanks,
Kathy

You can use a parameter query. Access will prompt for an unrecognised field name.
[CODE=sql]SELECT *
FROM tblJob
WHERE CompanyName Like [Prompt for beginning of company name] & '*';[/CODE]

[abolos]

Hi All,

I would like to retreive all the records that starts, where the field CompanyName in table tblJob start with "sap*"... i assume this can be acheived by using LIKE function in query design but i want the user to enter the text.

Say, there are two company Names like "sapin" and "sapeen"

when the user enters the text as "sap", it should list all the records where the company name starts with Sap..

and again, if the user enters, "ABC", i want access to list all records where the company name starts with ABC.

Any help in this regard.

thanks,
Kathy

Open a query and in Criteria write:

Like text0 & "*"

[kathnicole]

Thanks a lot. i was surprised to see the result.

it works good.

thanks n regards,
Kathy

[kepston]

Thanks a lot. i was surprised to see the result.

it works good.

thanks n regards,
Kathy

Always glad to help.