Prev: Access 2007
Next: how to create a custom paper size in Access 2007
From: Alan on 21 May 2010 09:09

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
From: RonaldoOneNil on 21 May 2010 09:16
..... [cbMonth] & "' And ([Revenue Stream Division] = 'Production' Or [Revenue
Stream Division] = 'Other')")


"Alan" wrote:

>
> 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
 | 
Pages: 1
Prev: Access 2007
Next: how to create a custom paper size in Access 2007