How to make a calculated field using a query not in the report.

[Konai]

Hello, I am trying to make a calculated field on a report that takes a number generated by one query and divides it by another number (obtained by another query) and display that number as a percent. I am having trouble finding the correct function to get this done with.

It should look something like this.

Sum of optionA is: 25 <-query1
with another field that is calculated out beside it looking something like this
=[query1].[field]/[query2].[field]
lets say query2 was 100 so it should look like...
Sum of optionA is: 25 and 25% of the whole chose A.

EDIT

=["optionA"]/[Personnel_Count]!["Personnel_Count"]
I was trying to use the above equation to calculate the number I needed. (made with the expression builder)
When I try to run the report with this in it, access asks me to enter [Personnel_Count].
I tried entering nothing and entering the correct number.
Both times that field displayed #Error on the report.

 

[Konai]

From what I have seen on other posts.. using a query is one way of putting extra calculations on a report. Which is exactly what I tried... If anyone knows why my reference to that query, ([Personnel_Count]!["Personnel_Count"]) is not working, I think it would work.

Could it be that the field name is the same as the query name?

 

[Konai]

Ok I know now how to do the calculated fields for reports. Solution found! , but it was all done inside of another query so that post can be found here in the query section.
http://www.access-programmers.co.uk/forums/showthread.php?p=918591#post918591