[AccessD] Debits and Credits

Arthur Fuller artful at rogers.com
Fri May 28 10:39:17 CDT 2004


>> 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




More information about the AccessD mailing list