Recent content by adrian94

Can you show me how to create that query? Thanks

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....

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

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...