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