Putting records in horizontal line

[JS]

I have a query that results in numerous waste codes for a specific profile.
However, I get duplicates of the profile for each waste code. I need this
information on a horizontal line. I have seen the other posts about the
generic function to concatenate, but I am new to these more advanced
applications and really need some step by step help. I looked at the module
in the generic function and I am kind of lost on what I need to change in
order for it to fit into my database. Please help.

 

[JS]

I work for a company that incinerates waste. We have waste profiles that are
assigned to different customers. Each profile has waste codes assigned to it
by the EPA. I am creating a report that shows profile information and
customer information. I created a query to pull all of the information. I
just end up with multiple entries for the profile because of the multiple
waste codes. I have roughly 15 fields in my query.

PROFILE WASTE CODE
APXADPF100 D001
APXADPF100 D002

 

[JS]

I have been searching all day and I am going to give you more information to
help solve my problem. First off, I have copied and pasted the generic
function to concatenate in my database. The two tables I am using are
EW_PROFILE and EW_PROFILE_WASTE_CODE. The tables are linked on the field
PROFILE. The field I am trying to concatenate is WASTE CODE. The query I am
running uses a parameter and from what I have seen, I am guessing I am going
to have to make another query to get the information how I want it and then
put it in the query I am using.