creating a report

[Apprentice101]

I have three tables with one to many relationships:
Customer table Products ordered table
Customer ---> prod1
prod2
prod3

customer table locations table
Customer ---> location1
location2
location3

I need to create a report that combines all of my customers with its correponding info on one row and concatenates all of the many corresponding locations into one column and products ordered. For instance

Report
Customer | All Locations | Products Ordered
Penzoil | loc1, loc2, loc | prod1, prod2, prod3,

What is the best appoach to do this with ACCESS? if you have any examples, would you please be so kind to share them?
thanks!
joey_trivia@hotmail.com

 

[lars7]

You should probably post this in the Reports Forum.

 

[Apprentice101]

thanks LArs7,

I will do that

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886