Sorting and Grouping

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: denilynn (denilynn_at_discussions.microsoft.com)
Date: 02/02/05 

Date: Wed, 2 Feb 2005 13:15:07 -0800

I have query that shows items and their sales totals (can have an item listed
more than once). I'd like my report to group items together with a total of
the sales for that item to appear also, sorted in descending order. 

-- 
Thanks in advance for your time!
denilynn

Relevant Pages

  • data source for a report
    ... I'm trying to understand how to put data into a report. ... specifically at the "Sales Totals by ... Amount" report. ... query, but there is no such table or query as "Sales Totals by Amount". ...
    (microsoft.public.access.tablesdbdesign)
  • Re: data source for a report
    ... > I'm trying to understand how to put data into a report. ... > Amount" report. ... > sheet for the whole report, I see the "Record Source" is "Sales Totals by ... > query, but there is no such table or query as "Sales Totals by Amount". ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Adding running total to union query
    ... Each query only represents one month, ... so that is why I would like to have the running sum within the union query. ... Monthly Sales Totals ...
    (microsoft.public.access.queries)
  • Re: Add Column Heading
    ... In report design view, choose Page Setup from the File menu. ... rather than allenbrowne at mvps dot org. ... > How can I add a heading to a column in my Access 2002 Report without ... > to group items. ...
    (microsoft.public.access.reports)
  • Rank Totals based on a query
    ... I am trying to do a Ranking of Sales totals. ... Can you rank based on a query that runs a grouping? ...
    (microsoft.public.access.queries)