Re: Sorting without grouping

Sheila D wrote:
>Marshal, I don't think I can have explained this very well. I have clients
>who make monthly support payments which may increase or decrease over time.
>What I would like to see in the report is most recent information 1st hence
>sort on date.
>
>However, I would like the information presented to show a total for each
>different monthly rate which may be over several months thus grouping and
>totals are on Monthly Rate. I can sort the dates within each Monthly Rate but
>can only sort the groups in ascending or descending order of the Monthly
>Rate. Sample data below which I hope clarifies.
>Rate per Month 85 No. of Payments 4
>01/07/2005 255 3 months
>01/06/2005 85 1 month
>Rate per Month 90 No. of Payments 15
>01/05/2005 270 3 months
>01/02/2005 270 3 months
>01/11/2004 270 3 months
>01/08/2004 270 3 months
>01/05/2004 270 3 months
>Rate per Month 95 No. of Payments 1
>01/08/2005 95 1 month
> Your help is appreciated and I'm sorry if I am missing something obvious
>here but I just can't see how to get the result I want


I don't think you're missing something obvious. Nothing
about this is obvious ;-)

If your sample above is the hoped for output, then it looks
like you want to group on rate then sort on date. But you
said you tried that it wasn't what you wanted, so at this
point I guess I wondering how you do want the result to
appear??

Just a stab in the dark now, maybe you do not want to group
on the rate at all, how about using a subreport in the sales
category group footer to display the total for each rate???

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: Is This Possible?
    ... I'm just a programmer/analyst who was given responsibility for all of the ... who's Bob Holmes in the big scheme ... Older versions called it "TopN/Group Sort". ... >> summing the group totals, you are summing the same thing as in the ...
    (microsoft.public.vb.crystal)
  • RE: formulas wont maintain during sort -help please!
    ... the totals in the first 265 rows. ... When I sort the second set, ... the formula references do not maintain the original cell ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Multi pages
    ... That is why I add the sort. ... When I add the sort and place the sum function ... THe source is just the query which does not have totals. ... totals of a few fields on the report, which it does fine with the sort, but I ...
    (microsoft.public.access.reports)
  • RE: Sort Data
    ... "bottom row is a total ".....don't allow excel to select the sort area. ... I do have a "helper column" as you mention with the date. ... taken by adding up the daily totals, the daily totals are every 9 rows. ...
    (microsoft.public.excel.misc)
  • the proceedings, orders, and griefs are all stupid and loyal
    ... Just failing since a offering out of the bedroom is too round for Ikram to cook it. ... To be holy or valid will campaign overall totals to regardless sense. ... It's an api that accesses some sort of indexed info, ... ...and the recipient confirmed delivery. ...
    (sci.crypt)
Loading