#Error In Query Problem

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
..
 
You must log in or register to reply here.

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
#Error in query 4
#Error in query 1
IIf Statement Error 3
IsError In Query - Handle #Error 2
Parameter Query with DSum 1
Overflow error on calculate field in query - Help Please 1

Back
Top