My Invoice form has six payment date/note/amount sets. That is, we can record up to six payments on any invoice, with each posting containing a date, a note (for the check number or other) and an amount.
I've made a programmed retrieve that will find a record that contains today's date in any of the date posting fields:
{ Payment_1_Date = @Date or Payment_2_Date = @Date or Payment_3_Date = @Date or Payment_4_Date = @Date or Payment_5_Date = @Date or Payment_6_Date = @Date }
This works well, and in fact I have saved variations which will retrieve previous days by just subtracting from @Date.
Now here's the wrinkle. Sometimes the payment is deposited to the Savings account, in which case the Payment Note field (Payment_1_Note, etc) will have the words "Savings Deposit" entered. Those need a special report run. I would like to add an AND statement to the above which will also search any of the six Note fields, retrieving any record which contains the word "Saving" (e.g. "..saving..").
This is giving me some trouble. None of the examples in the book (that I've seen so far, though I'll keep looking) show a programmed retrieve that uses wildcards. Is this even possible? I've tried
{as above} AND {Payment_1_Note = "..saving.."}
and
{as above} AND {Payment_1_Note = ..saving..}
(I'm starting with the first Note field because if I can find a syntax that works I'll expand it later with ORs).
Anyway, I'll keep experimenting. I'm gonna play with @INSTR next.