I am trying to set up a range in the index or filter options for an ole db report.
The range is like
(field >= 600 and field <=620_ or (field>=700 and field <=720).
Has anybody been able to set this up on the filter or index of a table in lawson. i have tried the , ; & | to give me a combination but oledb is not acceptiony any of these characters. It allows the first part but not the rest.
tia.