One-to-Many Relationship - Show into 1 field

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Modules / DAO / VBA / November 2006

One-to-Many Relationship - Show into 1 field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JF Bouthillier - 09 Nov 2006 17:39 GMT

Hi all,

I have two tables with a one-to-many relatioship. Table1 has projects and
Table2 has resources. What is the best way to show (in a report) for a
specific project all the resources separated by commas.

Thanks a lot.

Reply to this Message

kingston - 09 Nov 2006 19:46 GMT

Here's one way to do it:

http://www.accessmonster.com/Uwe/Forum.aspx/access-queries/35822/transpose-multi
ple-record-values-into-a-single-record#68035f3852b6euwe

>Hi all,
>
[quoted text clipped - 3 lines]
>
>Thanks a lot.

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.