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

  • Thread starter Thread starter Martin
  • Start date Start date
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
 
Hi

=DSum("[amount]","databasequeryMartin","[aaaaaa] = 'finished' or [aaaaaa]
='doing' or [aaaaaa] ='preparing'")
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dsum Issues 0
Autofilter problem 7
Access DSum Calculations adding a third optional criteria? 2
DSum Countrol Source Help 5
Help with expression 4
Help with DSUM 3
How do Icorrectly use the LookUp feature when the cells contain wo 1
How do I match cells in different columns with words in them? I u. 1

Back
Top