Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

UnConcatenate. 1

Status
Not open for further replies.
lars7

lars7

Technical User
Aug 16, 2005
817
GB


Hi there,
I got the following "IIf statement" to concatenate fields in my query from someone here but now I need to reverse it and seperate the fields can anyone help me:


Code: [jd code no] & IIf(IsNull([jd addit no]),"","/" & [jd addit no])
 
Sort by date Sort by votes
jd code no :iif(InStr(1, Code , "/")>0, Left(Code, InStr(1, Code , "\")-1), Code)
jd addit no:iif(InStr(1, Code , "/")>0, Mid(Code, InStr(1, Code , "/")+1), "")
 
Upvote 0 Downvote
Hi jerry,
I went on holiday for a few days after I posted this and forgot all about it untill I needed something similair today. Thanks it worked great.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

surfbum3000
  • Locked
  • Question
Unconcatenate Last Name, First Name Middle Initial
Replies
8
Views
155
Melagan
Melagan
surfbum3000
  • Locked
  • Question
Unconcatenate two fields 3
Replies
8
Views
62
surfbum3000
surfbum3000

Part and Inventory Search

Sponsor

Back
Top