[AccessD] Debits and Credits

Pacioli's treatise (The monk that started the whole mess) on accounting 
was written in Latin.
So the abbreviations.
cr
credo, credere, credidi, creditus  V
trust, entrust; commit/consign; believe, trust in, rely on, confide; 
suppose;
lend (money) to, make loans/give credit; believe/think/accept as true/be 
sure;
dr
debeo, debere, debui, debitus 
owe; be indebted/responsible for/obliged/bound/destined; ought, must, should

Arthur Fuller wrote:

>>>There is nothing to indicate dr or cr.
>>>      
>>>
>
>Does anyone happen to know the origin of "dr"? It's always puzzled me --
>an unlikely abbreviation of "debit". Not important, just wondering.
>
>And incidentally, why are terrorists always credited with their acts,
>rather than debited?
>
>Arthur
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
>Sent: Friday, May 28, 2004 10:20 AM
>To: 'Access Developers discussion and problem solving'
>Subject: RE: [AccessD] Help on Complicated record count query
>
>
>I'm bringing it in from a text file. There is nothing to indicate dr or
>cr. Jim Hale
>-----Original Message-----
>From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
>Sent: Thursday, May 27, 2004 12:04 PM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] Help on Complicated record count query
>
>
>Is there no DR/CR or debit/credit indicator in the records, or are you
>actually bringing it in from an image or a text file?
>
>Charlotte Foust
>
>-----Original Message-----
>From: Hale, Jim [mailto:Jim.Hale at fleetpride.com] 
>Sent: Thursday, May 27, 2004 8:41 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Help on Complicated record count query
>
>
>Using Monarch I have successfully parsed a bank statement file (6620
>records) into Access. Unfortunately deposits and withdrawals are both
>positive numbers. The problem I am having is determining where
>withdrawals begin so that I can flip the sign. Below are the relevant
>fields. SELECT tblBankStmt.fldDate, tblBankStmt.fldAmt,
>tblBankStmt.fldCustref, tblBankStmt.fldDescr FROM tblBankStmt;
>
>fldate is actually a text field with "04/01" - "04/30". Deposits are
>listed first with 4/1-4/30 in order. The withdrawals start over with
>4/1. There is nothing in the table to distinguish where withdrawal
>records start except that the date changes from 4/30 on the last deposit
>item back to 4/1 on the first withdrawal item. So I need an SQL criteria
>(or maybe an iif stmt on the amt field) that counts the number of
>deposit records and flips the sign on every record after that. I do not
>khow to do this so any help would appreciated. TIA
>
>Jim Hale
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada