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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated fields in MSQUERY
hi
is the data you are drawing into excel from the Access db you mentioned. if so, you might find it easier to write the query in access and use MSQ to draw the access query result in to excel. MSQ is good but has some limitation that access doesn't have. If your have critera, the critera(parameters) MUST be on the excel side otherwise you will get an error - too few paarameters. expected x. regards FSt1 "PeterW" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated fields in MSQUERY
Thanks - Unfortunateley the data is in a sage database not access. Do you
know if msquery allows this type of calculated field? "FSt1" wrote: hi is the data you are drawing into excel from the Access db you mentioned. if so, you might find it easier to write the query in access and use MSQ to draw the access query result in to excel. MSQ is good but has some limitation that access doesn't have. If your have critera, the critera(parameters) MUST be on the excel side otherwise you will get an error - too few paarameters. expected x. regards FSt1 "PeterW" wrote: 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 |
Reply |
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) |