I'm putting together a query in the query designer called qryClaims:
Field Table Total Show
Client Claims Group By checked
CaseName Claims Group By checked
cbShow Claims Group By checked
I double click on the query to see if it runs and as expected, it shows two lines for each case because of cbShow (yes/no).
It shows one line for true and one line for false.
Client CaseName ...other fields... cbShow
15141 Joe's BMW ...other dataset one... checkbox (checked)
15141 Joe's BMW ...other dataset two... checkbox (not checked)
My reports are set to record source qryClaims.
Statements are passed to filter the report depending on user selection:
([Client] = '15141') And ([cbShow] = True) << works
([Client] = '15141') And ([cbShow] = False) << works
([Client] = '15141') And ([cbShow] = True Or [cbShow] = False) << does not work
([Client] = '15141') << does not work
The third and fourth example should filter to the report ALL records for the case regardless of the state of the checkbox. In other words, show all records on the report.
The actual result that the "other dataset one" in the above test is being filtered to the report, most likely because it is the first line that matches the statement [Client] = '15141'. Both datasets should be filtered, should they not?
So the question is what should I use (or do) to get all records filtered to the report using the above query (qryClaims)?