Combining fields into one line

[NeedExcelHelp07]

I want to make a report off of a query. That query lists the name, id, and
items bought (Product). For each item bought, there's a new line with the
name and id and then the product purchased. I want to make a report that
lists the name, id, and then products purchased on one line per individual
name.

Below is what I have and then what I'm trying to get.

What I have:
Name ID Product
John Hascua 1234 computer
John Hascua 1234 Phone
John Hascua 1234 Monitor
Jeff Green 1524 computer
Jeff Green 1524 Memory Card

The way I would like the report to look:
Name ID Product
John Hascua 1234 computer, Phone, Mointor
Jeff Green 1524 computer, memory Card

Thanks!

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0008.htm at "The Access
Web"

 

[NeedExcelHelp07]

Where do I enter the code? In Query or in Reports?

Thanks!

 

[Douglas J. Steele]

Your choice.

You can create a query that uses the function as a computed field, or you
can set the ControlSource of a textbox on the report as a call to the
function. I think you'll find most people would recommend using the
ControlSource on the report approach, unless you need the information to be
available elsewhere.