 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / March 2007What Access function would = the folllowing from Excel: =MID(H31,1,FIND(",",H31)+5)
Access does not seem to have FIND function. I need to capture Last Name + Comma + First 4 Characters of First name. In the Mid function since last names are variable length, I need to determine the location of the comma within the field, then capture from 1 to Comma plus 5 characters. This works in Excel, and I updated Access to read as follows: =MID([Name],1,FIND(",",[Name])+5) Access does not like FIND though =Mid([Name],1,Instr(1,[Name],",")+5) > Access does not seem to have FIND function. I need to capture Last > Name + Comma + First 4 Characters of First name. In the Mid function [quoted text clipped - 7 lines] > > Access does not like FIND though In Access it's Instr(). Debug.Print Left("Whittle, Jerry",Instr("Whittle, Jerry",",")+ 5)  SignatureJerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > Access does not seem to have FIND function. I need to capture Last > Name + Comma + First 4 Characters of First name. In the Mid function [quoted text clipped - 7 lines] > > Access does not like FIND though =left([Name], instr(1,[Name],",") + 5) By the way it is bad practise to name a field or variable NAME It is also bad practise to have a field that contains both lastname and firstname > Access does not seem to have FIND function. I need to capture Last > Name + Comma + First 4 Characters of First name. In the Mid function [quoted text clipped - 7 lines] > > Access does not like FIND though |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.