Search results

  1. A

    SUMIF Function with Textbox Value

    Can you show me how to create that query? Thanks
  2. A

    SUMIF Function with Textbox Value

    Thanks Bob for the answer,but i don't know it shows error result: #Name? Even if I use =DSum("NettPrice", "[YourTableName]", "Currency = '"USD"'") It still shows #Name? hmmm... I confused....
  3. A

    SUMIF Function with Textbox Value

    sorry, I typo when copy that in this thread. but, in my program, I already use txtCurrency
  4. A

    SUMIF Function with Textbox Value

    Hello, I am currently working on a form. I used textbox to set the value of currency and sumif to total nett price for all of data with that specified currency. How can I get the value of the textbox? I use formula : =Sum(IIf([Currency]="USD",[NettPrice],0)) and it's worked. It sums up...
Back
Top Bottom