Search results

  1. C

    Sorting by Sum in a report

    This may be a simple question but I'm baffled. I have a report which groups sales by individual salesman and gives a sales total or aggregate ( Sum() ) for each individual, whether there is 1 or 5 sales. So far so good. Burt how do I then sort the total sales from highest to lowest in my report ?
  2. C

    Top 3 results

    This may be a simple problem, but I cannot find the solution myself. I need to design a query based on a table describing all sales during a year to a number of clients of my company. However , even if 50 sales may have been made during the year to some clients, I want the query to return only...
Back
Top Bottom