I've designed a report in table builder to search our fixed asset register for a particular term. The trouble is there are two places the value can appear:
1) In a dedicated field called Van Code; and
2) In the description
(for reasons I won't go in to, its not simply a case of going through the fixed asset register and employing a consistent naming convention)
In order to pick up all the relevant fixed assets, I therefore run the report twice, based on the below options. Copy out the table data each time and then combine them into one table afterwards.
Is there a way to configure the JET report to effectively do this for me? Effectively making the options an "either/or" filter rather than "and" filters as they currently are.