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

Thanks Brad. I appreciate your fishing results query sample. I do mostly
one off stuff and I use cross tabs a lot. I will sometimes have several of
them run as subqueries to a main query that links the pieces together for
the final presentation to the user which I generally do via an Excel output
file.

Good luck.

GK


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

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



-- 
Gary Kjos
garykjos at gmail.com