Merge Relational Data

[fenhow]

Hi,

I have two tables. A is master PK is TractID, B is Relational with a One to Many with A.

I am trying to run a query that will show only 1 PK with all the associated records in B in one field versus multiple records.

So for example, right now when I run the query it will add a record for each of the relational records in the DB.

I am trying to merge the relationals..

Can anyone assist?

Thanks.,

Fen

 

[pbaldy]

Does this work for you?

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

 

[fenhow]

Thanks, that looks like it will work but seems complicated, is there an eaiser way?

Thanks.

Fen

 

[pbaldy]

It and this one:

http://allenbrowne.com/func-concat.html

are more complicated than they need to be because they're designed to be used in a variety of circumstances. You could write your own using the basic technique of a function being passed a key value and returning the concatenated list that would be simpler. Either of these is cut/paste though, and then understanding how to use them.

 

[fenhow]

Hi, I cant get it to work. Would you mind taking a look at it if I send up the DB?

 

[pbaldy]

I should have time later.

 

[pervez]

Need help I put the example

I have 4 table with Like IdNo, Received, Money, CompanyName
IdNo, distrubute, money, companyName
Idno, Payments, money, companyName
IdNo, Penality, Money, companyName
When I want to summarize, I get results in query by joining field idno the results come 4 time higher. may be some expert understand my question.

 

[pbaldy]

It might help to post a sample of the data and the result you want to see.

 

[pervez]

It might help to post a sample of the data and the result you want to see.

I am too late and I am sorry for the late answer. I shifted my accommodation. I will give send you sample of the tables. At the moment I can not due to non availablity of the Internet access at home

Thanks