AnsweredAssumed Answered

Using script to find with AND and OR

Question asked by cpking on Jan 23, 2018
Latest reply on Jan 23, 2018 by beverly

I admit an an Access guy, so Filemaker is challenging me to do what I think are simple things...


I have a conference database that contains fields: Invoice Number, Invoice Paid (a date), and Product Name (a value list). One value is "Replaced."


I'm trying to create a report (layout) that pulls records where Product Name is NOT "Replaced," AND where the invoice field IS NOT blank and the Invoice paid IS blank.


I've seen posts about modifying finds, and don't have a clue what I'm doing.


Can someone please help me?