Concatenating 3 fields into one when you insert

[ScottNeth]

Ok, clarifying question I had before and hopefully answering Struth's question - I need to concatenate three fields into one (while also entering the three fields seperately) each time a record is added. I know how to run the SQL for this on a SQL server once all the data is there, but how do I drive it into the DB this way?
Cyberpunk Scott Neth
Web Designer/Cyberpunk

 

[schase]

It would look as if lets say you have three fields
fldArea, fldCity, fldCustID. - Now note I am picking through code that I know works from a gent who made it for me. Might need some tweaking.

Separately you would do like this

strQuery = "INSERT INTO tblScores ([fldArea],[fldCity],[fldCustID]) VALUES (" _
& "'" & Request.Form("fldArea&quot & "', " _
& "'" & Request.Form("fldCity&quot & "', " _
& "'" & Request.Form("fldCustID&quot & "') "
Conn.Execute strQuery

All together would look something like this. - what is in Blue you have to alter.

Set Conn = Server.CreateObject("ADODB.Connection&quot
Conn.Open strProvider
Conn.BeginTrans


strQuery = "INSERT INTO tblScores ([fldNumber],[fldArea],[fldCity],[fldCustID]) VALUES (" _
& "#" & Request.Form("fldArea&quot & "-" & Request.Form("fldCity&quot & "-" & Request.Form("fldCustID&quot & "#, " _
& "'" & Request.Form("fldArea&quot & "', " _
& "'" & Request.Form("fldCity&quot & "', " _
& "'" & Request.Form("fldCustID&quot & "') "
Conn.Execute strQuery "I like a man who grins when he fights."

-- Prime Minister Winston Churchill

Stuart