from sequent to row

[יריב החביב]

hello,

I have table with sequent numbers to unit.
it look like this:

unit number
a 1
a 2
a 3
b 2
b 6
b 7
c 3
c 4

I want to show the numbers in one row to unit.
like this:

unit numbers
a 1,2,3
b 2,6,7
c 3,4

HOW ?

THANK YOU

 

[Allen Browne]

Create code to loop through the related records, and concatenate the values
into a string.

Details:
http://www.mvps.org/access/modules/mdl0004.htm

 

[יריב החביב]

thank you allen

It is a bit sofisticated for me
isnt there somthing more simple ?

 

[Allen Browne]

Unfortunately, that's about the simplest solution.

At first glance, it looks more daunting than it is.
You can copy'n'paste the code, and then call it quite simply.

 

[יריב החביב]

THANK YOU VERY MUCH !

 

[יריב החביב]

hello allen,

when i put the ststement in the northwind exampel
its work fine.

but when i put it in my application and run the query
it tell me : "user-defined type not defined" (db as data base)

what shuld i do ?

 

[Allen Browne]

The function requires a reference to the DAO library.
All versions of Access have this by default except 2000 and 2002.

Open a code window, and choose References on the Tools menu.
Check the box beside:
Microsoft DAO 3.6 Library

I also suggest you replace the line:
Dim rs As Recordset
with
Dim rs As DAO.Recordset
since other libraries have a Recordset object as well.

More info about references:
http://allenbrowne.com/ser-38.html

 

[יריב החביב]

thank you allen,
now there is no error.

do i have to change some of the fields in order
to make it work in my application ?

 

[Allen Browne]

No. It should work like the Usage Examples.