When designing a query, having a column use a reference to another field works fine until I try and put a criterion on it at which point running the query brings up the "enter parameter value" box.
So this works:
Field fieldname Table tablename Criteria >5
And this works:
Field User Field Name: [tablename.fieldname] Table Criteria >5
And this works:
Field User Field Name: [tablename.fieldname] Other User Field Name:[User Field Name] + 1 Table Criteria
But this doesn't:
Field User Field Name: [tablename.fieldname] Other User Field Name:[User Field Name] + 1 Table Criteria >5
The actual query I'm making is more complex, with both fields involving formulas and I'd rather not repeat the formula in the second field - I want to just refer to it. I don't understand why this wouldn't work. Doesn't the second field simply represent a value that can have a criterion?