If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dcount syntax help
I have a databse with a table called Expenses. In that table I have a field
calles Vendors which is a text field and a field called Cost which is a currency field. I need to count the number of times that for example something was purchaed from Walmart so I used the syntax =dcount("[Vendor]","Expenses","[Vendor]='Walmart'") and that works my problem is with multiple conditions I need to count the number of times the vendor was walmart and the cost was more than $400.00 I tried =dcount("[Vendor]",'Expenses",'[Vendor='Walmart' AND [Cost]'$400.00'') and all I get is an error any suggestions would be most appreciated . Thanks is advance Tom |
#2
|
|||
|
|||
Dcount syntax help
See reply to your other post.
-- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "Tom" wrote in message news I have a databse with a table called Expenses. In that table I have a field calles Vendors which is a text field and a field called Cost which is a currency field. I need to count the number of times that for example something was purchaed from Walmart so I used the syntax =dcount("[Vendor]","Expenses","[Vendor]='Walmart'") and that works my problem is with multiple conditions I need to count the number of times the vendor was walmart and the cost was more than $400.00 I tried =dcount("[Vendor]",'Expenses",'[Vendor='Walmart' AND [Cost]'$400.00'') and all I get is an error any suggestions would be most appreciated . Thanks is advance Tom |
Thread Tools | |
Display Modes | |
|
|