Two selections in different list boxes are always interpreted as logical AND.
I would like to make it a logical OR. Is that possible in QV10?
To put this in context:
> There are two date fields (e.g. date1 and date2) from different tables
> There are two list boxes (date1 and date2)
> I would like to be able to filter and see (date1 OR date2) (something like an outer join)
Here's some sample data:
| List Box selection | A | B | C | D |
| DATE1 | 53,664 | 1,922 | 828 | 1,090 |
| DATE2 | 45,774 | 2,533 | 979 | 1,503 |
| DATE1 & DATE2 | 45,774 | 1,922 | 828 | 1,090 |
Some of the dates in table 1 do not have a correspondence against table 2 and vice verca.
I would like to be able to see Date1 OR Date2.
Thank you in advance
