Recent content by jazi

  1. J

    Calculations on Groups

    Sums and expressions maybe? make one column for country, next for gold, next for silver and last for bronzein a table. Than make a query, include all columns. Hit the total button in design view for query(big E). New fields will now show up in the columns (referred to as groupby's) The country...
  2. J

    2 Top N queries joined

    Hmm Anyone know?
  3. J

    2 Top N queries joined

    I figured but... Maybe I am typing it wrong Tried : SELECT * FROM Query4 UNION ALL SELECT * FROM Query5; However, I need 2 keep the col1 and col 2 seperate, I basically just need them to both be on one page, because I am making a graph that needs to use both values. Should I just be trying...
  4. 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...
  5. J

    Mail merge with Aggregate func

    SELECT Table1.Group, Table1.Month, Sum(Table1.Value1) AS SumOfValue1, Sum(Table1.Value2) AS SumOfValue2, Sum(Table1.Value3) AS SumOfValue3, Sum(Table1.Value4) AS SumOfValue4, Round(IIf([SumofValue1]=0,0,[SumofValue2]/[SumofValue1])*1000000,2) AS Expr1...
  6. J

    Mail merge with Aggregate func

    Thanks! The first one looks like it is it, I will try it. Thanks for your help!
  7. J

    Mail merge with Aggregate func

    Mail merge with aggreg func first off, thanks for answering. I dont understand what you mean by sort it out in access? Everything is sorted out already, it is just that the values I need are not in any field of any query or datatable. ] All it is, is one field's total divided by another...
  8. J

    Mail merge with Aggregate func

    What if I need more than just the totals? I have an expression that needs to divide one total by another, but again, that is in the report, not in the query.
  9. 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...
  10. J

    Top N Per Group

    Thanks! :D Thank you. That worked beautifully.
  11. J

    Top N Per Group

    This is my SQL Getting an error SELECT [PPM Data].ID, [PPM Data].Company, [PPM Data].[PPM Month], [PPM Data].[Grant Shipped], [PPM Data].[Grant Rejected], IIf([Grant Shipped]=0,0,[Grant Rejected]/[Grant Shipped])*1000000 AS [Monthly Grant PPM], [PPM Data].[Hart Shipped], [PPM Data].[Hart...
  12. 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...
  13. J

    dividing creates an #Error...

    Grr, I was going too fast, and I forgot, sorry for such a crappy Question! What if you want to add more of an equation to it, such as: =IIf([Grant Shipped]=0,0,(Sum[Grant Rejected]/Sum[Grant Shipped])*1000000) But I get a syntax error...any clues?
  14. J

    dividing creates an #Error...

    Still wondering... I put this equation in a new field, but now I have many fields with a ###### for all the fields that do not have zeros, and all the zero fields are just fine. What am I doing wrong?
Top Bottom