Recent content by Clarencephil

I should have thought about that ! I did it according to your suggestion (Joining totals query to original query and ordering by sales total ) and it worked perfect. Thanks for taking the time.

Maybe I was not clear ! I do not have an aggregate sales field. Just individual sales for each salesman What I did in myreport was sorting and grouping by salesman and I have a Sum(Sales) in the group footer, which gives aggregate sales by salesman. I would like however to be able to print a...

I'm already sorting and grouping by salesman. That's how I get their individual sales total or aggregate. But since I'm sorting by salesman, I'm getting: Salesman.........Aggregate sales Salesman A .. ....$ 5000 Salesman B . ..... $ 8000 salesman C ........$ 4000 Salesman D.........$ 9000...

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 ?

OK Sorry, I tried Method 1 again and got it to work. I had forgotten to remove the _ in the subquery (from the supplied example) . I had not tried Method No.2. Thanks a lot. You went through a lot of effort. Well appreciated.

Method 1: I tried it with my database: did not work Strangely enough, I tried it by curiosity with the Northwind datase : did not work either (try it). There must be a better or simpler way :confused:

Thanks for the advice. I'm not sure we're talking about the same thing (or at least, it does not seem to be working). Suppose I have a table with the following companies and sales: Company/.. Sales /.. Date Comp.A $15 000 27 April 05 Comp.B $ 15 000 ...

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...