Table builder "Either/or" filter" option

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.


Please sign in to leave a comment.