How to concatenate several entries to same table

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I have a situation where a part can be composed of several
materials. So I created a table that collects the key
things about the part and another table that allows input
for the materials/inv# for each part. What I want to do
now is write a query/report that concatenates all the
materials for the part into one field:
Current data:
Part# Material
PART001A Plastic
PART001A Wood
PART001A Glass

Desired Outcome
PART001A Plastic,Wood,Glass
 
Hi Ann,

Here's an article that performs something similar to what you are
attempting to accomplish:

ACC2000: How to Combine Multiple Child Records into One Record
http://support.microsoft.com/default.aspx?scid=kb;en-us;322813

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Ann" <[email protected]>
| Sender: "Ann" <[email protected]>
| Subject: How to concatenate several entries to same table
| Date: Tue, 9 Mar 2004 14:53:43 -0800
| Lines: 14
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQGKV9Ep5WFUgctRFKBpJRMJk+IRQ==
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.queries:193040
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.queries
|
| I have a situation where a part can be composed of several
| materials. So I created a table that collects the key
| things about the part and another table that allows input
| for the materials/inv# for each part. What I want to do
| now is write a query/report that concatenates all the
| materials for the part into one field:
| Current data:
| Part# Material
| PART001A Plastic
| PART001A Wood
| PART001A Glass
|
| Desired Outcome
| PART001A Plastic,Wood,Glass
|
 
Hi Eric,
The reference you sent me works exactly like I'd like it
to in the Northwind dB. I'm new to VBA so I tried copying
the module as is from the example to my db and then tried
to setup and run the query but I get a "user-defined type
not defined" as soon as the query hits the module call and
#Error as a result.
Any new suggestions other then learn VBA?
-Debbie
 
Back
Top