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