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?

value = Sum(tablename.fieldname)

Something like that should work.