Report field queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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;
 
Back
Top