Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Report field queries

Discussion in 'Information Technology' started by H2OBOWL, Jul 28, 2006.

  1. H2OBOWL

    H2OBOWL
    Expand Collapse
    Guest

    In my Checkbook db, I'd like to have a report where one field is the sum of
    all debit transactions in a table and another field that is the sum of only
    the transactions that haven't cleared (they have no post date in their
    record). How can I do this?
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Try this --
    SELECT Null AS Outstanding_Debit, Sum(YourTable.debit) AS Paid_Debit
    FROM YourTable, YourTable AS YourTable_1
    WHERE (((YourTable.YourDate) Is Not Null))
    UNION ALL SELECT Sum(YourTable.debit) AS Paid_Debit, Null AS Expr2
    FROM YourTable, YourTable AS YourTable_1;


    "H2OBOWL" wrote:

    > In my Checkbook db, I'd like to have a report where one field is the sum of
    > all debit transactions in a table and another field that is the sum of only
    > the transactions that haven't cleared (they have no post date in their
    > record). How can I do this?
     

Share This Page