I have added this to a query
Category: iIF([Number of total miles for this week]<=15,"turtle", iIF(Eval([Number of total miles for this week] Between 15 And 36),"fox", iIF([Number of total miles for this week]>=36,"lion", " ")))
It functions as expected in Access.
However, when I try to pull the query into Excel, the query that has the above included no longer shows on list of queries in the database.
Category: iIF([Number of total miles for this week]<=15,"turtle", iIF(Eval([Number of total miles for this week] Between 15 And 36),"fox", iIF([Number of total miles for this week]>=36,"lion", " ")))
It functions as expected in Access.
However, when I try to pull the query into Excel, the query that has the above included no longer shows on list of queries in the database.