Find Records with Conditions
We have a Layout (Report) based on a Vendor_Invoice table. The table has columns of Vendor_Name, January_Invoice, ..., December_Invoice. How can we just show Vendors that have missing monthly invoice (=0), regardless of which month?
We have try "Perform Find" and "Enter Find Mode". But have problem of specifying conditions (basically January_Invoice=0 OR ... OR December_Invoice=0) in either methods. Can anyone help? Thanks.