Query

  • Thread starter Thread starter Gary F Shelton
  • Start date Start date
G

Gary F Shelton

Need help with this excel statment that I want to do in Access as a query.

=IF(BQ2<0.9,BQ2,IF(AND(BQ2>=0.9,BQ2<1),"MTD FCST <
10%",IF(AND(BQ2>=1,BQ2<1.2),"MTD FCST exceeds FCST but acceptable","over
FCST")))
 
The following all on one line

IIF([FieldName]<0.9,[FieldName],
IIF([FieldName]>=.9 and [FieldName]<1,"MTD FCST < 10%",
IIF([FieldName]<1.2 and [FieldName]>=1,"MTD FCST Exceeds FCST but
Acceptable","Over FCST")))

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