Reusing a calculated field in another field

[PearlGI]

Here's the situation:

I have a query that has 2 calculated fields, I then need a 3rd field which is based on a calculation of the first 2, eg.

Field3 wants to equal Field1 / Field2

This works fine until I specify a criteria on Field3. When I run the query with a criteria, Access prompts me to 'Enter Parameter Value' for Fields 1 & 2!!

I'm sure it's got something to do with how Fields 1 & 2 are referred to in Field3. Is there another way to refer to them apart from just:

Field3: [Field1] / [Field2]


And before anyone suggests it, yes I know I could just replace the references to Fields 1 & 2 with their actual calculations in Field3. But due to the size of the calculations involved I'm looking for an alternative solution.

Many Thanks.

 

[KKilfoil]

Create a new query and use the existing query as the data source.

All fields in the existing query will be treated equally by the new query, including the calculated ones.

 

[PearlGI]

Thanks for that idea.

It was obvious if I thought about it! My eyes were clouded by looking for a more complex answer!!


However, (as I'm always looking to expand my knowledge) does anyone know if it's possible to solve the original problem in just 1 query?