Query criteria question, quick answer needed

[greenfalcon]

Thanks for helping me out with this question. Im sure this is pretty easy to do. I have a query with a few paramaters set up... one of them runs a custom function all i want to do is this

query one
Average water flow:Avg([WaterFlow])

when run this just shows me the average water flow for the database... now if i have another criteria i want to base off the average how do i get the query to realize that. for example it would look something like this

[Average water flow]/[currentFlow]

how do i reference another criteria? hopefully this isnt to hard to understand.

 

[greenfalcon]

I found out a way to do this, just thought i would share my answer, I ended up creating two queries, one that summarized all the data and then the second one to query the first. This makes the query run much faster as the custom function is only being run on the summarized data instead of the entire database!

Thanks

Jason