 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Update statement...concantenate text
I wanto concatenate text in the field like MY123, MY234 under same field. Below are my code:- mySQL6 = "UPDATE WIPRawDetails SET SerialNumber = SerialNumber & '" & Me. txtI_SerialNumber & "' WHERE PartNumber= '" & Me.txtPartNumber & "' AND JobNumber = '" & strJobNumber & "'" Debug.Print mySQL6 DoCmd.RunSQL mySQL6 I managed to get that but I need a comma to separate it...Can someone help me? >I wanto concatenate text in the field like MY123, MY234 under same field. As noted in the other thread... THIS IS A VERY BAD IDEA. Could you explain *why* you think you want to do this? John W. Vinson [MVP] |
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
|
©2009 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.