 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
Iff statement
I am writing a report with Access 2003, but having some issues with the proper way to put the iff statement in the control source.
What I need to show in the text box is the sum of 3 tables but only if the customerid =1. Currently this is what is listed in the control source. =IIf(([CustomerID]="1"),([documents]+[addl_pages]+[wasted_paper]),0) It only brings back 1 result. Not all the sum based on the date. Bascially, what I need is my report to sum (by date) all the totals but only if the customerid is 1. Thanks! Matt |
||||
Check out some similar questions!
Hi I would like someone to check to see if I did this correctly, if I did not then please help. Thanks The Problem is: The following pretax amounts pertain to River Corp. for the year ended December 31, 2008. Sales... $400,000 Operating Expenses... 84,000 Extraordinary gain... 30,000...
Les Fleurs, a boutique in Paris, France, had the following accounts in its accounting records at December 31, 20X2 (amounts in Euros, denoted as "E") Purchases………………... E250,000 Freight In……………… E8,000 Sales discounts…………. 4,000 Purchase returns…….. 7,000 Inventory Sales…………………. ...
Here's the problem: The Hobart Company incurred the following transactions during 2003: A. Acquired $50,000 of cash capital from owners B. Paid $10,000 to acquire manufacturing equipment C. Paid $5,000 cash for materials used in production D. Paid $2,000 for wages of production workers...
Deleted, sorry put it in the wrong place
I was in USA from Feb06-Jul05 on L2 visa.I need to file taxes .I did not apply for EAD and so I do not have SSN.Do I need to submit a statement with ITIN application that I am not eligible for SSN.Can I send my ITIN application along with tax returns? Somewhere I read that the stamenent is...
View more questions Search
| Question Tools | Search this Question |
Add your answer here.
|
