How do I fix this?
I have a query, were I've renamed a field.
I then am referring to that field in another fields expression.
When I do, it asks for the renamed field parameter. See below.
Well, it appears that you cannot review to renamed field within the same query. I guess...
I got rid of the renamed fields and referred to the field with the related query that it came form.
Is that reason?
You can still rename your field (more correctly called giving them an Alias) but simply refer to your original field name with the source table name before the field name - as per your second example.