Hey guys, I'm trying to recreate an old report using MS Access. I'm displaying a list of products in a database. In the report, I want to show a total quantity of each product. I also want to show the different warehouse locations for the product. The old report, which was a web report developed years ago had the following format:
Product, Count, Location
Product name (ProductID), Total count of product, Locations listed here (i.e. D21d01, D22b02, D32c01, etc.)
*Note: I'd have more space between each column, separated currently by commas above. Evidently this site doesn't like if I try to just put a bunch of space between each column here.
So essentially, the top of the page would show the header for each column. And then list a product followed by the total quantity on hand for that item over multiple locations for it and then the list of those multiple locations. And then it would go from there to the next product and so on. I'm trying to decide how I can even list this all. To throw it all into the Detail portion of the report would clearly not work. Unless I need to just create a new field or fields and just write code to concatenate together all those locations for each product in order to display them how I want, along with writing code to total up the overall quantity of each item. Thoughts?
*Edit*
Here's a sample from the old report. Mine will not have all the fields but should give a better idea of the formatting I'm looking for.