Search not filtering after I add additional "Where" clause in the recordset
I have a page with payments and charges that is filtered by begin date and end date. I do not want to show any zero values in the filtered report and therefor I have added a Where in the recordset:
WHERE PaymentDebit > 0 OR PaymentCredit > 0
Without the 'OR PaymentCredit > 0' Date filtering works but after adding it all records are shown and there is no filtering.
I've attached the page for you to inspect. The result must be that records are filtered according to begin and end date and that items with a 0 in PaymentDebit AND 0 in PaymentCredit should not be shown which would be a 0 value record.