Recent content by welcomesui@gmail.com

Hi Spikepl, Can I let us know how to write this query. Regards, Hari

Hi All, I have a table that contians more than 70,000 rows, where I want to export the table as two different excel files. 1. One excel file data from 1 to 65000 rows 2. Second excel file from 65000 to end of table. Can any one help in this regard. Regards, HARI

Hi, Can I use InStr(1,[YourFiledName],"Ltd",0)<>"0" Or InStr(1,[YourFiledName],"LTd",0)<>"0" Or InStr(1,[YourFiledName],"LTD",0)<>"0" Or InStr(1,[YourFiledName],"lTD",0)<>"0" in one expr1.

Hi vbaInet, how can I search multiple text strings in one expr1.

Many More thanks

Hi All, I need to search case sensitive text in a filed I need to find out the data with “Ltd” only from below data ABL BIO-TECHNOLOGIES LTD ABL BIO-TECHNOLOGIES LtD ABL BIO-TECHNOLOGIES ltd ABL BIO-TECHNOLOGIES lTD ABL BIO-TECHNOLOGIES Ltd I am useing below query but it giving all the...

the sample data provided as tested data with two ways.. from name to abb and abb to name. if the filed4 contians any abb those abbreviations are need to modify with new name, if no abbreviations are found, keep the old data. I think no inconsistency my data.

ID | Field4 | Required ---------------------------------------------- 1 ICI Bank,ADR, pfd ICI Bank,American Dep Rep, Preferred Stock 2 Man Bank, pfd Man Bank, Preferred Stock 3 Yes Bank...

It is giving the only abbvaitons not total data It should return along with the data in Field4

I changed the code as suggested same problems repeats Find sample attached

it is in Standard Module Only, Module4 is used this function

it is stopping the query and returns as Runtime error 5 Invalied Procedure or Argument Hari

it's around 20-30

Hi, as per my understanding if the Filed4 contains only ADR it replace to ADR I hope we have a little bit of miscommunication about understanding. in my ADR table Filed4 not only contians ADR, it contians along with other Text Also Adr ID | Field4 | Required...

yes.. I did the same thing as below. Created table with three coumns table name Abb ID. PK FieldName -American Dep Receipt FieldAbb -ADR My main table contians five columns as ADR ID. PK Filed1 Field2 Field3 Field4 - Contians Name Created new query Added two tables Inner JOIN with ID...