Display content from different enteries from the same table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gadflyjs - 14 Feb 2008 07:26 GMT

I have two tables here, one contain the basc info of several items, said 10
items, and using an ID to identify them; the second table, store the records
related to those items at the first table, using a different id to identify
these records and linked the first table with the item ID. since there may be
more than one record for each items, so the second table has more entries,
said total 50 records.

What I want to do is, to make a query that show all 10 items, and followed
with all related records (combine together, separate with space).
Any thought?

Thanks in advance.

Reply to this Message

Allen Browne - 14 Feb 2008 08:49 GMT

Use a VBA function to concatenate the values form the related table into a
string.

For details, see the code in this article:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have two tables here, one contain the basc info of several items, said 10
> items, and using an ID to identify them; the second table, store the
[quoted text clipped - 11 lines]
>
> Thanks in advance.

Reply to this Message