Combine record

[dede]

Hi guys..
is there any query to do this action:
i want to combine view record into a single record.
exm.

table 1
Name A B
Jack 10 22
jack 12 21
jack ... ....
jack 1 11
ben 12 2
ben 3 2
ben ... ...

into:
View 1
Name combine
jack 10,22 and 12,21and1,11 and .....
ben 12,2 and 3,2 and......

thx before..

 

[Robert Morley]

Not that I can think of. You'd have to write a custom function to produce
results like that.


Rob

 

[Sylvain Lafontaine]

For JET/Access or SQL-Server? For SQL-Server, see Anith Sen:
http://groups.google.com/group/microsoft.public.sqlserver.programming/msg/2d85bf366dd9e73e

Another possibility would be to create the result using a temporary table
(with maybe a cursor).

For JET, you can write your own VBA function in the same way. (But I you
want more information, you should ask in a more appropriate newsgroup than
this one.)

 

[dede]

I have tried to make some function but i can't figure out, but thanks
any way,

 

[Sylvain Lafontaine]

Hum, from your two previous posts, we don't even know if you are working
with JET/Access or with SQL-Server; so what kind of answer did you expect?

 

[Doug Robbins - Word MVP]

See
http://groups.google.com/group/micr...osoft.public.access*&rnum=21#8f1a0db232d314a1

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Malcolm Cook]

if you're in mssql 2005 you can create a user defined aggregate function to concatenate strings, as per
http://msdn2.microsoft.com/en-us/library/ms182741.aspx