Result format (1 Viewer)

[msp]

Hi,

I have a query that is trying to find out which systems are on a server.

I have a server table, and system table and a link table between them. When I run a query for example server 1 I get the result in the following format.

Server 1, SystemA
Server 1, SystemB

This denotes that the server is part of two system. However I would like to show the results in the format below is this possible?

Server 1 , SystemA, SystemB

Thanks for any assistance.

 

[namliam]

SJ McAbney (aka Mile-o-Phile) did something just like that a while ago cant remember where or when.... but search and you will find....

Regards

This is more or less the same Question as:
http://www.access-programmers.co.uk/forums/showthread.php?p=331442

 

[KenHigg]

Mailman, I get some kind of error msg on the link you posted.

Ken

 

[namliam]

It works now, tho it dont matter much they both say the same... Search for the solution under Mile...

Regardz

 

[msp]

The current SQL I have is.

SELECT data_server.Server_Name, data_System_1.System_Name
FROM ((data_server INNER JOIN (data_System INNER JOIN data_System_Membership ON (data_System_Membership.System_Name = data_System.System_ID) AND (data_System.System_ID = data_System_Membership.System_Name)) ON data_server.SERVER_ID = data_System_Membership.Server_Name) INNER JOIN data_System_Membership AS data_System_Membership_1 ON data_server.SERVER_ID = data_System_Membership_1.Server_Name) INNER JOIN data_System AS data_System_1 ON data_System_Membership_1.System_Name = data_System_1.System_ID
GROUP BY data_System.System_Name, data_server.Server_Name, data_System_1.System_Name.

I have searched and cannot find anything as yet. I did see the code on the link above but have not managed to get it to work. - thanks for any help...

 

[KenHigg]

Could you adapt something like the following:

link
???
kh

 

[msp]

Ken,

That's great thanks,,