AnsweredAssumed Answered

Find Records with Conditions

Question asked by LeoCA on Jun 19, 2009
Latest reply on Jun 22, 2009 by LeoCA


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.