Update statement...concantenate text

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

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.
Click to expand...

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace function 2
importing data 1
text to column/row 3
Text feild check for pattern or if last 5 are numeric? 1
Creating an Oracle UPDATE Statement from Excel rows 1
Help with SQL insert into 2 one to one relationship tables 1
Ctrl-V to text box locks up SQL statement in code? 2
SQL and updating text question 1

Back
Top