Using query formula information to create another formula in a seperate query

[waffle]

I have a query that calculates input information into a value that then needs to be compared to another query values and will be used to output a % change in a third query. Is there any way to make this happen? Thank you in advance!

 

[KeithG]

You could try and do something with Dlookup function to retrieve the values from the queries.

 

[waffle]

Keith, thank you thank you thank you.... that was such an easy fix!