[AccessD] Access Report Sub-Totals - Need to Display Differently

Gary Kjos garykjos at gmail.com
Thu Sep 26 14:29:48 CDT 2013


Well a cross tab query does that. But not sure how that works with a report
since the columns are dynamic based on the data.


On Thu, Sep 26, 2013 at 1:47 PM, Brad Marks <BradM at blackforestltd.com>wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com


More information about the AccessD mailing list