No, their are a number of third party products but Query/400 doesn’t do conditionals
Impossible no, not at all!!
Create three queries
– query #1 selects only records with lnt03=34 and has a result field TXTFLD value ‘advance’
it sends output to a tempfile
– query #2 selects only records with Int03 <> 34 and has a result field TXTFLD value ‘payoff’
it <ul>adds</ul> records to the file
– query #3 creates a report from the file.