Calculated fields in MSQUERY

  • Thread starter Thread starter PeterW
  • Start date Start date
P

PeterW

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
 
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
 
Thanks - Unfortunateley the data is in a sage database not access. Do you
know if msquery allows this type of calculated field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

msquery in Excel 2007 1
Access Query problem 1
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
MSQuery Parameter in WHERE defaulting to All 1
SQL ODBC MSQuery in EXCEL 1
Find Access Database Used by MSQuery in Excel 2003 1
Help with MSQuery & CAST function 3
sum of calculated fields in header of report 1

Back
Top