E ewart Registered User. Local time Today, 03:40 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, 21:40 Joined Feb 26, 2001 Messages 4,013 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.