select two option to one criteria

  • Thread starter Thread starter Alan
  • Start date Start date
A

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
 
..... [cbMonth] & "' And ([Revenue Stream Division] = 'Production' Or [Revenue
Stream Division] = 'Other')")
 
Back
Top