Run time error

[samotek]

In my record source for the report i get the runtime error 3075 saying that i have an extra ) in the expression.Could you help me to find it out ?

" WHERE (Month([InvoiceDate])=Forms!Switchboard!Monaten OR Forms!Switchboard!Monaten Is Null) AND (Customers.afid=Forms!Switchboard!Office OR
Forms!Switchboard!Office Is Null) AND ((orders.invoicedate) Between #1/1/2008# And #12/31/2008#))" & _
" ORDER BY [order details].liters DESC;"

 

[MajP]

((orders.invoicedate) Between #1/1/2008# And #12/31/2008#))"

 

[JBinQLD]

samo, Majp is correct - the simple way to do this is to read your expression from the start and counting the opens in your head - obvoius add 1 to your count for each ( and deduct 1 for each ). Doing this to your expression would result in this monologue:

1 open, 2 open, 1 open, none open, 1 open,none open, 2 open, 1 open, none open, oops! Got one left over, there's my prob...

JB