What's wrong with this "DSum=" sentence ?

M

Martin

I want to calculate the AMOUNT for the condition of FIELD aaaaaa =
"finish" or "doing" or "preparing"

What's wrong with this sentence?

=DSum("[amount]","databasequeryMartin","[aaaaaa] = 'finished'or 'doing' or
'preparing'")


I think, the mistake is in: "[aaaaaa] = 'finished'or 'doing' or
'preparing'"


Yet, how to make it correctly?


Thanks!



Martin
 
A

Arvi Laanemets

Hi

=DSum("[amount]","databasequeryMartin","[aaaaaa] = 'finished' or [aaaaaa]
='doing' or [aaaaaa] ='preparing'")
 
M

Martin

Thank you very much. It really works!

I am too drunk in the programming :p

Arvi Laanemets said:
Hi

=DSum("[amount]","databasequeryMartin","[aaaaaa] = 'finished' or [aaaaaa]
='doing' or [aaaaaa] ='preparing'")


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )



Martin said:
I want to calculate the AMOUNT for the condition of FIELD aaaaaa =
"finish" or "doing" or "preparing"

What's wrong with this sentence?

=DSum("[amount]","databasequeryMartin","[aaaaaa] = 'finished'or 'doing'
or 'preparing'")


I think, the mistake is in: "[aaaaaa] = 'finished'or 'doing' or
'preparing'"


Yet, how to make it correctly?


Thanks!



Martin
Click to expand...
Click to expand...
 
Top