Query to look for accounts with both positive and negative values
Posted on 2014-03-21
I have a table (tblInvoices) that has three (relevant) fields:
Some of the invoice amounts are positive and some are negative.
I'm looking for a query that will show all the accounts that have both positive and negative invoice amounts (i.e. an account that has at least one invoice that is positive and at least one invoice that is negative).
It doesn't matter to me if the query results show just one line for each matching AccountNumber of if the query results show all the invoices for each matching AccountNumber.
Thanks in advance!