| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated fields in MSQUERY
I am new to query and struggling with a conditional field value. I want to
include the actual amount for a cost type if there is a match or 0 if no match. I am trying IIF(Fieldname = "APP",FIELDNAME2,0) This works ok in access but I get a 'Column not found message' in query. Is it not possible to do this or am I missing something? Grateful for any suggestions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Calculated Items on Calculated Fields. | Excel Worksheet Functions | |||
| Help with pivot calculated fields? | Excel Discussion (Misc queries) | |||
| Delete All calculated fields | Excel Discussion (Misc queries) | |||
| Calculated fields | Excel Discussion (Misc queries) | |||
| Calculated Fields in Pivot | Excel Discussion (Misc queries) | |||
Threaded Mode
