I am having trouble with the following expression in a select query not working.
Expr5: IIf([Forms]![frmreports]![cbBusNumber]="All","All",[busnumberA] Or [busnumberB])
If I change the query to the following I am able to retrieve data from my query
Expr5: IIf([Forms]![frmReports]![cbBusnumber]="All","All",[busnumberA])
But only if the bus number is in "busnumberA" field.
Expr5: IIf([Forms]![frmReports]![cbBusnumber]="All","All",[busnumberB])
But only if the bus number is in "busnumberB" field.
I do need to enter a bus number from either "busnumberA" or "BusnumberB" fields
I do require the second field from my table "busnumberB" to also be part of the expression as I am querying a particular bus number where the passengers may be on either "busnumberA" and/or "busnumberB"
Thanks Josh