I have a query with an expression that compares [SoldDate] to today's date and displays a value in months using the DateDiff() function. I have a second expression to evaluate the first expression and assign a letter based on the value. It would either assign: A,B,C, or D. The query is running correctly at this point.
The problem I am having is I need to set a criteria on the second expression. It is simply = "C". When I try to set the criteria, I get a parameter prompt for the first expression.
Any ideas why this is occuring?
In reality, I don't need to use the second expression. However it would be nice.