Newbies michaelbluejay Posted January 21, 2005 Newbies Share Posted January 21, 2005 Hi, this is my first post here. I tried to see if this question has been addressed before but if so I couldn't find it. Anyway, I'm trying to make the simplest flat-file general ledger but I can't figure out how to sum the accounts. The database is simple: Each record has just the date, amount, debit account, credit account, and description. So far so good. But I don't know how to sum each account. The problem is that for a given set of records for a given account, some of the amounts will be debits and some will be credits, and I don't know how to check for each one. I can't just sum the Amount field -- some of those entries need + values and some need - values depending on whether they're debits or credits. The only solution I know of is to search for a debit account, record the total on a piece of paper, then search for a credit account, and subtract its total from the first total. Seems like that's a waste of owning a computer, though. I don't mind creating a separate script for each and every account. I just don't know how to set it up to even write the first script. Thanks very much for your help. Link to comment Share on other sites More sharing options...
This topic is 6631 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now