Brad Marks
BradM at blackforestltd.com
Thu Sep 26 13:47:27 CDT 2013
All, I have an existing Access 2007 Report which shows sub-totals for "Part Categories" like this. (Detail records are not shown) ______________________________________ Date Part-Category Nbr-of-Parts 9/1/2013 Rings 10 9/1/2013 Pins 50 9/1/2013 Medallions 25 ______________________________________ Recently there has been a request to display this data on the report in a different fashion, with the "Parts-Category" being shown in the heading like this and then have only one line for each date. ______________________________________ Date Rings Pins Medallions 9/1/2013 10 50 25 ______________________________________ I would like to use Access reporting "Built-in" features to do this. Any ideas/advice? Thanks, Brad