select two option to one criteria

[Alan]

thanks for you help yesterday with a dsum
just one quick question

this code below

..... [cbMonth] & "' And [Revenue Stream Division] = 'Production'")

how do i get it to select "Others" as well in [Revenue Stream Division]

so something like [Revenue Stream Division] = 'Production' & 'other'")

but that didn't work

thanks

 

[RonaldoOneNil]

..... [cbMonth] & "' And ([Revenue Stream Division] = 'Production' Or [Revenue
Stream Division] = 'Other')")