MS Access IIF
There is a task type column and a cost column. I need to pull out only the costs related to the task type steel. I was thinking an IIf ( [tast type] = steel, sum, 0 ) statement would work. Not making it happen. Any ideas? I actually want to pull out all of the different types of costs seperately and sum there totals. This will be put into a report.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 26, 2008 9:16 PM
UPDATED:
May 27, 2008 1:43 PM
RELATED QUESTIONS
- SQL reporting
- Copy Data from an entire row in Excel 2003 Sheet to another sheet in the same workbook automatically
- How to assign a numerical value to a word in Excel
- In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?
- Function with hours & minutes involved
Answer Wiki:
Hello Keg,
if I understood well your answer, your query shoule look like this:
<pre>
SELECT (SELECT SUM(COST) FROM MY TABLE WHERE [TASK TYPE]= 'STEEL') AS STEEL_COST FROM MY TABLE</pre>
Regards.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
