I am trying to select invoice records that are exceptions. For example:

"Invoice_Amount" does not equal "Approved_Amount"   “or”
"Vendor_Number" does not equal "Approved_Vendor_Number"

My syntax within the Details - Select Expert Record formula is this:

{APM_MASTER__INVOICE_PAYMENT.Bank_Account} = {?Bank Account} and
{APM_MASTER__CHECK.Check_Date} = {?Check Date Range} and
{AP_Invoice.Approved_Amount} <> {APM_MASTER__INVOICE_PAYMENT.Amount_Paid} or
{AP_Invoice.Approved_Vendor_Number} <> {APM_MASTER__INVOICE_PAYMENT.Vendor}

Basically the report crashes every time I run it, or returns no data. Not sure if it just overloads the computer or what.

Any ideas as to what could be causing this? Is my syntax right?


Thanks in advance!!!