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

Gary,

Just for you... 
______________________________________

 Date      Fish-Species     Nbr-of-Fish

 9/30/2013   Walleye            06
 9/30/2013   Northern           15
 9/30/2013   Lake Trout         11
 9/30/2013   Muskie             01

______________________________________


Thanks for the tip on the cross tab query.  I haven't worked with these
much.  Only some preliminary experimenting a couple years ago.

Brad




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Thursday, September 26, 2013 2:30 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Report Sub-Totals - Need to Display
Differently

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

--
This message was scanned by ESVA and is believed to be clean.
Click here to report this message as spam. 
http://h0stname/cgi-bin/learn-msg.cgi?id=DAA9D28C9A.BF06C