ADO: Help build this query in MS Access
in [Visual Basic]
|
Prev: Just happened to be scanning the web for something on VB6 and came across this monstrosity
Next: Help: Visual Basic Setup Problems
From: Faraz Azhar on 30 Jan 2010 07:49 Hello I have a very large table in a MS Access database. It has various fields in it. (Eg. Field1, Field2, Field3, Field4, Field5) All I'm trying to do is to run a query that concatenates the values in 3 fields and returns a recordset. In other words, I want a recordset which has only one field and that field contains the values as follows field2+field3+field4. Example: Field1 Field2 Field3 Field4 Field5 1 AA XX PQR 112 2 BB XX STS 234 3 CC XX QQQ 234 My query should return a recordset which should have only one field. The values of that one field would be: AAXXPQR BBXXSTS CCXXQQQ Any suggestions?
From: MikeD on 30 Jan 2010 16:52
"Faraz Azhar" <itzfaraz(a)gmail.com> wrote in message news:ae7589b0-76bb-4050-ac46-76a1bd6f0153(a)t17g2000prg.googlegroups.com... > Hello > > I have a very large table in a MS Access database. It has various > fields in it. (Eg. Field1, Field2, Field3, Field4, Field5) > > All I'm trying to do is to run a query that concatenates the values in > 3 fields and returns a recordset. > > In other words, I want a recordset which has only one field and that > field contains the values as follows field2+field3+field4. > > Example: > > Field1 Field2 Field3 Field4 Field5 > 1 AA XX PQR 112 > 2 BB XX STS 234 > 3 CC XX QQQ 234 > > My query should return a recordset which should have only one field. > The values of that one field would be: > > AAXXPQR > BBXXSTS > CCXXQQQ > > Any suggestions? What have you tried? It's expected that you try first. If you encounter problems, then ask (and post relevant code). Norm gave you an answer, but I have to kinda question that...which I will do in a reply to Norm. And really, this has more to do with SQL programming than with VB. -- Mike |