[AccessD] Debits and Credits

Probably "Debit Record", but considering this thread is about a bank
produced file which does not distinguish between debits and credits, but
instead leaves it up the reader (human or machine) to figure it out, it's
just as likely to mean "Dubious Report".

Lambert

> -----Original Message-----
> From:	Arthur Fuller [SMTP:artful at rogers.com]
> Sent:	Friday, May 28, 2004 11:39 AM
> To:	'Access Developers discussion and problem solving'
> Subject:	[AccessD] Debits and Credits
> 
> >> 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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com