Search results

  1. J

    2 Top N queries joined

    Col1 Col2 A 10 10 B 15 15 C 20 12 D 25 9 E 30 20 F 35 18 G 40 2 H 50 23 I 55 1 J 60 18 I have to get...
  2. J

    Mail merge with Aggregate func

    Morning! I have quite a few aggregate functions within a report I produced based on 2 queries. I need to do a mail merge with this information, but it is not all in one single query, because I cannot get an expression using totals in a field. How do you get these aggregate functions to be a...
  3. J

    Top N Per Group

    I know you have probably seen this a trillion times, but being new to all this, it is discouraging to say the least! Please help... I think maybe I should upload the database, let me know. Here are the names: Table name: PPM Data Fields: Company PPM Month PPM Amount There are 10 different...
Top Bottom