Lance, You can't post attachments to this user forum.
Peace, Kevin Hoctor No Thirst Software LLC http://nothirst.com Sent from my iPhone On Apr 9, 2009, at 12:46 AM, Lance <[email protected]> wrote: > Trying the attachment again ... > > > > > -- Script to output "Cleared/Reconciled" account balance (excludes > "Open" and "Pending" transactions) > -- Note: assumes you have no split transactions in "Open" status > > select sum(zt.zamount) from ztransaction as zt,zaccount as za where > zt.zaccount = za.z_pk and za.zname = "Checking" and zt.zdate >= > (select zdatein from zrollover where zisinitialrollover = 1) and > (zt.ziscleared = 1 or zt.zisreconciled = 1 or zt.zissplitchild =1) > and zt.zispending = 0; > .exit > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "No Thirst Software User Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/no-thirst-software?hl=en -~----------~----~----~----~------~----~------~--~---
