Merge Query rows in a new one

[Mr.Access]

Dear Friends,

I have 2 tables .. (GroupNo.) & (employee)

The conjunction between them as :

tbl1 tbl2
--------------------------
No. Name
--------------------------
1 John
1 Alian
1 Sali
2 Robert
2 ......
...
..
.
---------------------------

How Can I make a new Query that produce the result as :

1 John,Alian,Sali
2 Robert,.......
3 ......


Kind Regards,

 

[pbaldy]

This type of thing?

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

 

[Mr.Access]

Hi pbaldy,

I got the message (Undefined Function "fConcatChild" in expression) .

What I did was :

>>Copy the following "Select Statement" to the (SQL View) of a new query :

SELECT Orders.*, fConcatChild("Order Details","OrderID","Quantity","Long",[OrderID]) AS SubFormValuesFROM Orders;

>> Create a new Module and Paste the CODE ,in the Link, .

>> Run the query .

the Error Came ....

Any ideas ?

Many thanks in advane .

 

[Rabbie]

Have you put the code for fConcatChild into a VBA module in your DB. Until you do you will get the "Undefinded Function" message.

 

[Mr.Access]

Yes I did.

I've created a Module with a name "fConcatChild" , but still the query can't

recognize it ?!

Any Ideas ?

Thanks.

 

[Rabbie]

The module should not have the same name as the function. That will stop it from working.

 

[Mr.Access]

Oh!

Ambiguous name. in query expression 'fConcatChild("Order Details","OrderID","Quantity","Long",[OrderID])' .

What should I do with this message ?

Thanks.

 

[pbaldy]

As Rabbie mentioned, the function must have a different name than the module. Change the name of the module.