#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
..
 
Back
Top