I'm trying to create a query where as it would bring back matching debits/credits amounts.
E ewart Registered User. Local time Today, 04:24 Joined May 22, 2002 Messages 10 May 22, 2002 #1 I'm trying to create a query where as it would bring back matching debits/credits amounts.
L llkhoutx Registered User. Local time Yesterday, 22:24 Joined Feb 26, 2001 Messages 4,018 May 23, 2002 #2 Create a new column in your query testing debit equaling credit, if they're equal, set an indicator, otherwise not. Filter on the indicator.
Create a new column in your query testing debit equaling credit, if they're equal, set an indicator, otherwise not. Filter on the indicator.