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?