Recent content by Chetan Kumar

Hi All, In Excel We used =REPLACE(A2,1,FIND("(",A2,1),"") for find and replace the string but in access what we used behalf of find plz help.

yes, but dear i'm looking for how can we execute our own function ??

Hi All, Anyone can tell me about string split functions how to use ........... I'm new on that platform so please help me please tell how many kind of string inbuilt function we have or if we create our on function so how to call that function in your query... please suggest thanks Chetan

hello hi how r u

Hi all, thanks i have already answer but i want to know all the way in which we can handle that kind of data.......so throw macro its going awesome its really working beautiful ......................so thanks for every thing

Any Idea Plzzzzzzzzzzzzzzzzz??????:confused::banghead:

Hi All, Please Suggest me how can I split long string throw query please give some examples I have records something like that: K Mirza (905) 820-6791 3759 Nightstar Dr Mississauga ON L5M 8A5 K Mistry Shailesh (905) 501-0311 518 Galaxy Crt Mississauga ON L5R 2R2 K MOHAMED (905)...

Thank you very much dear for such a great help:)

Hi Paul good morning, Could you please help me about my query? I have one access file with contain that kind of data… How can I split that file first field which contains data? In same table next fields without macro ….:confused: Please help me out Plz Chetan Kumar Raghuwanshi

thanks thanks

Yes I tried its working very well.. thanks thank you very much.....:)

It's working with 2007 Access or not?????

Thanku Very Much...... I'll try that function then tell u further action....Thanks

Some time data something like that....... A & A De Vera (905) 495-9939 61 Baha Cres Brampton ON L7A 2J4 A & C Wagar (905) 430-1318 41 Scadding Ave Whitby ON L1N 9X4 A & J Pender (905) 735-7098 142 Muirfield Trail Welland ON L3B 6G7 A & K Zeller (905) 765-3996 53 Harrison Rd...

Yes Calgary is the city.