#Error In Query Problem

G

Guest

I have a query where in one column I have a calculation that is suppose to
return a "G", "Y", or "R". However, due to non-existing values for some
instances of the data used in the calculation, I get "#Error" for those
values. However, I'd like to get the "#Error" to be replaced with "NA".
I've struggled with IIf and IsError, but no luck. Any suggestions would be
greatly appreciated. Thanks is advance.
 
J

John Spencer

Hard to say since you didn't post the calculation

IIF([Your Column] is Null, "NA", <<your current calculation goes here>>)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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

Access Query problem 1
Time in calculated field for shifts going past midnight 0
Checking if data exists another table and, if yes, extracting a value 0
IIf Statement Error 3
Parameter Query with DSum 1
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
#Error in query 1
How to use IsError()? 1

Top